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, 4 months ago by Andrew Jackson.

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

Author

Posts
August 11, 2015 at 12:32 pm #451 Score: 0

Lincoln Burrows
Moderator

Karma: 16 pts

I try to run DBCC CHECKDB with repair option it says “Attempt to BEGIN TRANSACTION in database ‘testdb’ failed because database is in BYPASS RECOVERYmode”

If I try to reset the status, the database again goes in Suspect state and it seems DBCC commands don’t run on database in Suspect state.

Does anybody know how to recover the database in this Mode? Is there any other way to repair it?

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 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.