Browse by Tags

Why Backup, Why Recovery? You need a good strategy to save your data!

Published 12 March 8 3:2 AM | SSQA.net

The following context is the one I have received from SQL Server Magazine that talks about a good backup tool in the market, study on: Third-Party Tool Enhances SQL Server Backup and Recovery Microsoft SQL Server’s own backup and restore facilities are...

Filed under: sql server, databases, backup, red-gate, recovery, toolkit, third party, strategy

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