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)


    Because before the drive failed, I have seen a couple of times that the bak file is only a couple of Kbyte while it should be around 200 MB. At that time I ran the backup manually then I could get a good backup.

    So, no I don't know 100% that the backup it corrupted but since the data hard drive had gone bad and for the fact that it had backup problem before I think most likely the bak file is corrupted too.

    Sorry I don't know about the recovery model.

    Thanks,

    Howard.

    Your latest full sized .bak file might be as good as you can get.

    Hopefully it was saved somewhere safe.

    Like Gail and Jeff mentioned, you should get some qualified local help.

    Especially if this was a real important database.

    Part of that should include more planning for just such a disaster.

    Lucky is it never happening.

    Good is being able to handle it with little business impact.