Windows Forum

Ask something
Discussion Locked

SQL 7 Win2K Server RECOVERY of Databases

0 helpful
5 replies

by dallen 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I just started working for this new company. Any ways there Win 2000 Server crashed (Motherboard) that ran SQL 7 Server. Needless to say "they" never performed any backups. I was however able to install the server drives in my workstation, and recover all of the data (I just can't boot them, gives me a stop error). So now I have installed a clean server on a new machine. Is there anyway to revover the Databases from SQL 7? I tried to just copy it over, but as I thought it didn't work. Any suggestions......

If I put the old server HD in a new machine is there a way to recover without getting a stop error?
On a side note, I am now authorized to implement a backup solution!!

5 replies

by steved

If you have the .mdf and .ldf files from the old server, the following procedure should work:

On the new server, create a new database for each user db that was on the old server. Delete (or rename) the .mdf and .ldf files that get created. Then copy your old ones over into the Data folder.

I hope this helps.

Steve Diamond

by shanghai sam

This may have worked logically, but You forget that the master DB holds all references. Therefor I don't think this would work as master would not recognize it. Thank you for the response though!

by steved

Well, it's not just theory. It has worked in practice for me, up to a point. There may be some objects stored in Master that have to be reconstructed after the fact, but it's a whole lot better than no recovery at all.

This discussion is closed to new replies.