Home Forums SQL Server 2005 Administering missing .mdf and .ldf database file after hard drive crash RE: missing .mdf and .ldf database file after hard drive crash

  • hwp (3/24/2014)


    Hi All,

    Thank you for the reply. The hard drive that crashed was actually the DATA drive.

    And the backup is corrupted as well, plus it is a .bak file. It doesn't have .mdf and .ldf file.

    Sorry, a total noob here.

    Thanks,

    Howard.

    First of all, Moden is right. STOP EVERYTHING and get to an expert. You could accidentally destroy data without knowing it. Do you need references for good experts?

    As Gail said, you may need a data recovery company. www.gillware.com is the best at the most reasonable prices. Beware that the company may not be able to resolve a crashed drive to the point of finding anything you can use.

    In the future, if you recover:

    1. Back up your database daily to a NAS or other destination that is not the same physical media as your MDF or LDF file. If the data are critical, use full recovery model and back up the transaction logs every 5-30 minutes, to that separate location.

    2. A second stage backup should be taken DAILY of that NAS to tape or the cloud or somewhere. What if the NAS fails too?

    3. Test restores should be done at least monthly to another location to ensure backup integrity.

    There is nothing more traumatic to a DBA than the total loss of a database. I hope and pray that you can recover!

    Thanks

    John.