Friday 8 November 2013

Suspected Database Recovery Query

If you find that your any database is suspected then plz restore your recent backup its recommended solution. If you have not your recent backup of this suspected database then you will use this given query with your Divisional Head permission.

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER  

No comments:

Post a Comment