March 16, 2006 at 6:56 am
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?
March 16, 2006 at 8:13 am
Are you sure it's location wasn't on ANOTHER drive?
-SQLBill
March 16, 2006 at 8:28 am
Positive; only one drive on these develoment servers. They're set up to be easily rebuilt.
April 25, 2006 at 1:43 pm
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
April 27, 2006 at 2:28 am
Search for file name .mdf
ex:your DB name is xyz mdf file name may be xyz.mdf
April 27, 2006 at 2:32 am
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