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
where 'Test_Database' is the suspect database
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