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 ...
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