How to Recover Database In SUSPECT Mode?

Lincoln Burrows ~ Modified: August 11th, 2015 ~ ~ 1 Minute Reading

This topic has 2 replies, 3 voices, and was last updated 9 years, 7 months ago by Andrew Jackson.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
August 12, 2015 at 11:49 am #456 Score: 0

Stephen West
Moderator

Karma: 4 pts

copy the data out of that database into a new one, vigorously check the logical consistency of the tables then discard the original database.

September 2, 2015 at 10:35 am #550 Score: 0
Andrew Jackson
Moderator

Karma: 1 pt
use this script to recover database from suspect mode
```
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
```
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.