Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com 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
add comment

3 Answers 3

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
1  
You forgot 4th point: look for a new job ;) –  TomTom Mar 23 '10 at 7:05
add comment

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
add comment

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
add comment

Your Answer

 
discard

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