Systems Engineering and RDBMS

SQL Server – Suspect Database

Posted by decipherinfosys on March 28, 2008

Here is an excellent post by Tibor Karaszi on the steps/actions for a corrupt or a suspect SQL Server database:

http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp

It is rare to encounter this in actual production environment but it can happen nevertheless and the list above gives you an idea on what to do under such situations. Also, here is an older post by Brian Knight about the same topic – even though it mentions SQL 7 and 2000, the steps are still valid.

One Response to “SQL Server – Suspect Database”

  1. […] server role can then access the database. It is especially useful if you have encountered a “suspect” database state before. You can now set it in an emergency mode and fix errors.  One can set […]

Sorry, the comment form is closed at this time.

 
%d bloggers like this: