Disaster Recovery

[Warren O Reilly]

Hi,
A test server I was developing on has died and all of my good work was on it.
However I have a copy of the Data folder containing the folloing files:

Test_Data.MDF

Test_Log.LDF

Is it possible to restore my database from these files?
If so how would I go about it?

Many thanks in advance!

[David]

Warren,

I am probably the least person to answer this but, it sounds like you should be able to do a sp_attach_db with that file. BOL has pretty helpful information here. Let me know if this works or if you would like any additional information here.

David


------------
Warren O Reilly at 2/2/01 8:54:20 AM

Hi,
A test server I was developing on has died and all of my good work was on it.
However I have a copy of the Data folder containing the folloing files:

Test_Data.MDF

Test_Log.LDF

Is it possible to restore my database from these files?
If so how would I go about it?

Many thanks in advance!