MDF missing

  • I have come across something that I've yet encountered.  We had a power outage and one server would not come up.  We rebuilt the system with a new drive and went forward.  (It's a development machine)

    I took the old harddrive home with me to see if I could get anything off of it.  I found that while I could not boot to that drive, I could still use it as a slave.  I noticed that one mdf file for one of the databases was gone like it had never been on the system.  The ldf was there, but no mdf.  Even if the mdf was corrupted or unusable, I'd still expect to at least see the file in the file system.

    Any ideas as to how the mdf went missing?

     

  • Are you sure it's location wasn't on ANOTHER drive?

    -SQLBill

  • Positive; only one drive on these develoment servers.  They're set up to be easily rebuilt.

  • You should be able to verify where the datafile should have been located by querying the sysdatabases table.  It lists the location of the primary mdf file.  Just a double check.

    Tom

     

  • Search for file name .mdf

    ex:your DB name is xyz mdf file name may be xyz.mdf

  • search file name yourDBname.mdf

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply