Monday, November 23, 2009

How Do I recover my Suspect database in sql server 2005

 Here is the code to recover the suspect database in sql server 2005,
query to recover suspect database is

ALTER DATABASE Test_Database SET SINGLE_USER

DBCC CheckDB (Test_Database , REPAIR_ALLOW_DATA_LOSS

ALTER DATABASE Test_Database SET MULTI_USER


where 'Test_Database' is the suspect database

No comments:

Post a Comment