Repair a corrupt SQL database in SQL 2005
My server crashed. most stuff lost.  I recovered the .mdf .ldf files through DaRT. I can not use the files. It advises that the header is corrupt.  Please advise what the best way to resolve this is.
September 6th, 2015 6:52am

Use your most recent backup taken for the database. File recovery such that you have tried has little chance for success (as you have noteiced) so restoring a SQL Server backup is most often the only solution.
Free Windows Admin Tool Kit Click here and download it now
September 6th, 2015 1:48pm

If you cannot attach the files, then I agree to TIBOR, use your most recent backup to restore the Database. If the DB was using a FULL recovery model with frequent T-Log backups, You should be g
September 6th, 2015 2:41pm

Fully agreed with TiborK but I don't think you have backup of database as you have already tried data recovery tool to recover your mdf/ldf files.

SQL database can be repaired by DBCC CHECKDB's repair options but there is risk of data loss.

  • Set database in single user mode
  • Run DBCC CHECKDB with repair_allow_data_loss
  • Set database in multi user mode

Hope this will helpful for you!!

Free Windows Admin Tool Kit Click here and download it now
September 7th, 2015 2:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics