How To Fix A Suspect Database – SQL Server 2005

I was running a resource-intensive reindexing script when my CPU froze for about 15 mins without any sign of “thawing”. Being an impatient idiot, I reached for the power button to reboot. Back to the SSMS….. aaaand the database has gone suspect, GREAT! *with sarcasm* Well, since this is a non-production database, there’s no issue [...]

Read Full Post »