How to fix database Consistency errors

The best option is to restore from a known good backup - and apply all transaction log backups from that point forward to current point in time.

You also need to insure that the page verify option on all of your databases has been changed to CHECKSUM and you want to enabled CHECKSUM on your backups as well. This won't help the current situation but it will help identify corruption issues better.

And finally - you need to fix the IO problems with the server and/or storage as that is the cause of the problems.

1 Like