Browse by Tags

Recover a database with no transaction log file - SQL Server 2005!

Published 11 November 8 1:16 AM | SqlServer-QA.net

Have you ever been in a situation that one of the database has been giving hard time! It may be the times that every DBA might go through this path without realising the root cause of the issue. The issue could be out of space on the drive where that...

Filed under: sql server, ssms, error log, suspect, 2005, corrupted, detach, attach, dataabase

Recovery of database 'dbname' (10) is 17% complete (approximately 31602 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.

Published 5 September 7 3:13 AM | SSQA.net

Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for...

Filed under: sql server, performance, databases, sqlagent, error log, recovery, suspect, message