Microsoft – SQL Server – Database Repair

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:

  1. Take regular full and incremental backups
  2. 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 )
  3. Pay attention to your SQL Server Error Logs and OS Event Viewer Log
  4. Review your HBA Cards (QLogic / Brocade) Logs
  5. 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])
  6. And, most importantly friend Paul Randle who wrote most of the original DBCC CheckDBs) in SQL Server

Please per-use the references listed below.

References:

  1. Repair vs Restore Dileama http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/07/620319.aspx
  2. Paul Randle – Repair
    http://www.sqlskills.com/blogs/paul/category/Repair.aspx
  3. Paul Randle – Unexpected consistency checks
    http://technet.microsoft.com/en-us/magazine/2009.10.sqlqa.aspx
  4. How to troubleshoot Msg 824
    http://support.microsoft.com/kb/2015756
  5. How to trouble Database Consistency errors
    http://support.microsoft.com/kb/2015748
  6. Understanding and managing the suspect pages table
    http://msdn.microsoft.com/en-us/library/ms191301(v=sql.105).aspx
  7. SQL Server Page Restore
    http://beyondrelational.com/modules/24/syndicated/500/posts/12128/sql-server-page-restore.aspx
  8. Single User Mode in Mirrored Database
    http://www.sqlservercentral.com/Forums/Topic1206207-1549-1.aspx

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s