Darkness SUSPECT MODE

Splat:

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

And many, many, many ,many hours later, c'mon ice cream.

For whatever reason the first time I tried it, it crapped out, and since it was a one shot deal, I choose to err on the side of caution and pursue other avenues. I did make a copy first. Once the ball was rolling on the other recovery methods and reached a critical point I tackled this again, but this time, basically took the server off the network to ensure isolation. Serious serious marklar.


Comments :

0 comments to “Darkness SUSPECT MODE”