September 3, 2002 at 2:18 pm
I have 2 SQL 7.0 servers.
One is the production and the other is a test server that was restored from the production server and the server name renamed. So bascially, it has the same setting as the production except the data is old now.
I have a book.mdf database backup while the production SQL server services were shuted down. I would like to uplode this book.mdf to the test server. How do I go about doing this. I know I have to shutdown the test server's services and copy over the card.mdf over. Is this the correct way and am I missing any steps.
TIA
Ken
September 3, 2002 at 3:59 pm
You can attach this without shutting down the server.
Steve Jones
September 4, 2002 at 3:34 am
Hi
Copy the book.mdf to the test server then
use sp_sttach_db to attach the mdf file to the book database on the test server.
More information from MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp
Tim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply