Hello,
I have a DB (22 gigs big) that is suspect and not working anymore.
I found this repaircode on internet:
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
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