Saturday 1 November 2014

How to recover SQL Server database from suspect?

Hi friends,  May you face the situation, that your database in SQL Server shows in  suspect mode

 

Now I have a solution for that, Just try this  may it will help you guys to recover it.
here is the code ...

EXEC Sp_resetstatus 'AgriculturalDB';
ALTER DATABASE agriculturaldb SET emergency
DBCC checkdb('AgriculturalDB') ALTER DATABASE agriculturaldb
SET single_user WITH ROLLBACK immediate
DBCC checkdb ('AgriculturalDB', repair_allow_data_loss)
ALTER DATABASE agriculturaldb SET multi_user 



here .AgriculturalDB  Is my suspected database name 

Simple one na, Khush karooo :)

No comments:

Post a Comment