July 12, 2002 at 4:08 pm
I recently had a development machine go down. The only thing I was able to save from the crash was the data directory but I'm unable to get those files working with a new install. Is there any way to restore my db from just the .mdf / .ldf files from another server. Any help would be much appreciated as half my design and about 40 sp's went down the drain since my last good backup. Thanks
<matt>
July 12, 2002 at 4:39 pm
Yes, that technique works well. If you just want a "normal" db you can reinstall and then just attach it. For master and msdb, the method described works well.
Andy
July 12, 2002 at 5:08 pm
Thanks, Everything is back up and running... Saved me a lot of work!!!
FYI:
My issue lied in the different drive letters that the data dir was installed on. I restored my last good Backup then replaced the .mdf/.ldf with the more current ones. As long as the drive letters / paths were the same I had no problems.
Thanks again
<matt>
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply