Friday, August 12, 2011

Database goes into suspect mode when server shutdown unexpectedly

The database goes into suspect mode.
If the Database is setup in Full  mode of recovery and there is no Log Backup.Atleast Please try to resolve with minimum data loss.

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

No comments:

Post a Comment