Suspect Database

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to check and correct the issue. And sql server dba has to monitor it.

Check the database consistence using

DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS

And try to understand the messages.

Don’t be panic and make any wrong decision.

Never try this at first:

  • Don’t Restart sql services
  • Don’t detach database
  • Don’t run checkdb “REPAIR_ALLOW_DATA_LOSS ” at first
  • Don’t direct restore the database. – you may have to do it but lastly.
  • DBCC REBUILD_LOG.
  • Don’t delete anything( data/log /backup/ any file)

First analyze and then take action.

Generally if it’s a IO issue, once IO is back just set the database to offline and bring it back to online will work.

There is a great blog posts by Father of sql server “Paul Randal” on this – MUST READ:

http://sqlskills.com/BLOGS/PAUL/category/Corruption.aspx

Hope you never come across database to “Suspect” or “Recovery Pending”

 

Advertisements
This entry was posted in Backup and Restore, Disaster Recovery, Experts, Troubleshooting and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s