Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am Looking For Best Way or Software To Recover Corrupt Database in SQL 2000/2005/2008 . looking for Ur help .......................................

share|improve this question

migrated from Mar 23 '10 at 7:01

This question came from our site for professional and enthusiast programmers.

Not a programming question - nudging over to SU. – paxdiablo Mar 23 '10 at 6:36
Backup and recovery is an Admin issue - should be on Server Fault. – APC Mar 23 '10 at 6:37

If you don't have a backup and if it is in suspect mode:

  • Set your database into emergency mode, then single_user mode.
  • Run DBCC checkdb with repair_allow_data_loss
  • Set to multi_user mode and try to recover your data. Of course, some data might have been lost during repair.
share|improve this answer
You forgot 4th point: look for a new job ;) – TomTom Mar 23 '10 at 7:05

Dont do it. Point. it is corrupte - if this is only indices (DBCC tells you), drop and recreat ethem. If not - the corrupt data is lost.

Take your backup, apply it. Then apply the transaction logs since last backup. Finished.

If you have no backup, look for another job.

share|improve this answer

Don't take our advice. Read some articles written by Paul Randal, who wrote the DBCC CHECK utilities for sql server.

Corruption Recovery Tips, Database Shrinkage Advice and More

Paul's DBCC CHECKDB blog series on MSDN

Paul's Blog

It would also help if you described the corruption problem your having with some specific error messages your getting from SQL Server.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.