Suspect Database DB SQL Server

userxyz · Jul 19, 2017

Hello,

I have a DB (22 gigs big) that is suspect and not working anymore.

I found this repaircode on internet:

Code:

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

The query is now allready running 1 hour and 30 minutes. Is this normal ? And will the DB be repaired in this way ?

Anyone with SQL experience can help me out ?

kind regards,

Gerry

sigmadelta · Jul 19, 2017

Since you've started down this road... let it continue. I had a corrupted MS Access database which took a few hours to repair... and that was only a few hundred megabytes.

Dazy · Jul 20, 2017

Code:

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

In the following code, you did not set the database into Single user mode. The second thing is, here is the chance of data loss because you are using DBCC CHECKDB option with REPAIR_ALLOW_DATA_LOSS option.

I will suggest trying the free version of this SQL database repair software to fix Suspect mode issue.

Good Luck!

sigmadelta · Jul 20, 2017

PS: Always backup your database! I hope you took a copy before doing this.

I used Stellar Phoenix to repair my MS Access database, worked well!

Kassia · Aug 7, 2019

fix suspect database

It's quite common that the database is suspected, the best way is to always keep a backup. I have met such an issue, and I used the Bitwar to rescue my suspect database, you can also have a try.

Kassia · Aug 7, 2019

And here you can refer to the website: < https://www.bitwar.net

Suspect Database DB SQL Server

userxyz

Member

sigmadelta

Member

Dazy

Member

sigmadelta

Member

Kassia

Member

Kassia

Member

Similar Topics