Tuesday, May 1, 2012

Suspect databases are not cool

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.

No comments:

Post a Comment