Dba days are always fun. I came in Monday morning to a list of suspect databases. I think this was a SAn issue. But, I still can not prove it. This is what i did to repair them.
Step 1:
Use Master
Go
Sp_resetstatus 'Database
Name'
--The above command will reset the status flag of the suspect
database.
Step 2:-- Once
the command is executed you need to restart the SQL services and check
the
status of the database.
Step
3: Execute the below query to check the integrity of the
database
Dbcc Checkdb('Database
Name')
Step 4: None of these worked, so I ended up restoring the database from a previous day.
