Microsoft – SQL Server – Database Repair
Many years ago, when your hard-drive crashes you want to look for \ to “Norton Disk Doctor”.
Another excellent tool is Gibson’s SpinRite.
These days, if you are running Microsoft SQL Server you want do the following:
- Take regular full and incremental backups
- Set your database mode to PAGE_VERIFY CHECKSUM / TURN_PAGE_DETECTION ( Sunil Agarwal – Enabling CheckSum in SQL Server 2005 http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/29/enabling-checksum-in-sql2005.aspx )
- Pay attention to your SQL Server Error Logs and OS Event Viewer Log
- Review your HBA Cards (QLogic / Brocade) Logs
- Understand everything in your IO Path (Placement of your data & log files, configuration of your HBA cards, Anti-Virus Tools certification for your OS, File System Filters [compression, Security \ encryption])
- And, most importantly friend Paul Randle who wrote most of the original DBCC CheckDBs) in SQL Server
Please per-use the references listed below.
- Repair vs Restore Dileama http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/07/620319.aspx
- Paul Randle – Repair
- Paul Randle – Unexpected consistency checks
- How to troubleshoot Msg 824
- How to trouble Database Consistency errors
- Understanding and managing the suspect pages table
- SQL Server Page Restore
- Single User Mode in Mirrored Database