Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If and when corruption is detected, the safest (and sometimes only) way to recover lost data is to restore from a backup. It's therefore a good practice to run DBCC CHECKDB at least often enough that should corruption be detected, your backup frequency and retention period will allow you to restore back to before the problem occurred.

 

Excerpt
IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > >