SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

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.

published 559 days, 23 hours ago posted by

sa 568 days, 23 hours, 30 minutes ago

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.

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...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: backups, Best Practices, CHECKDB, CHECKSUM, database consistency, dbcc, Restore, SQL Server, veirify only

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

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.

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up