So I try and browse over to http://www.csharpfriends.com and I notice that my custom error page is rendering. I quickly terminal server into my box and open up the web.config and change the error page setting to false so I can see what's going. It turns out my sql login is having problems, so I open up EM and I notice my database is greyed out with the label (Suspect) beside it!
I quickly google to find out what's going on and it turns out there are a number of reasons why sql server flags a database as suspect. Some of them are:
- the database could be curropt
- the operating system is somehow locking up the database (backup software, virus scanning?)
- database restoration fails for some reason
- log file is missing
Anyhow, I created a backup of my database a few days ago so I quickly rolled back to that version. I tried looking in my sqlserver log file but nothing really stood out to me, and I must admit I was a little stressed so I took the short cut! *smile*
For those of you who are interested, here are some links that I found on the subject of database's being marked suspect:
I always ran a quick checkdsk on my servers hard drive to ensure my drive was in good shape.