SQL Server log messages: Analysis of database is 0% complete (approximately 0 seconds remain). Phase 1 of 3. This is an informational message only. No

BACKUPS are key to recover the data during the disaster recovery, but many times just taking backups is not sufficient as you need to ensure the backups are good enough with no corruption. The subject line message though classified as an information message, recently one of the databases were taking long time to finish the recovery whenever the SQL Server has been restarted and also during the RESTORE operations. Not an issue if this a Development environment but in the case of agreed downtime this...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2010/07/19/sql-server-log-messages-analysis-of-database-is-0-complete-approximately-0-seconds-remain-phase-1-of-3-this-is-an-informational-message-only-no-user-action-is-required.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9326" width="1" height="1">