I am trying to restore a database from a production server to a test
server with a different database name.
The test server has a database with the same name as the one on
production, and also has the database with a different name.

From logical_name x_dat physical_name d:\x_dat
to logical_name dx_date physical_name d:\dx_dat

There is already a database on the server with
logical_name x_dat physical_name d:\x_dat
I don't want to overwrite this database.

Every time I try to run the restore it tells me I am trying to overwrite
an existing database.
I just want to make sure I am not writing to the x_dat version of the
database.

I do this all the time. I don't know why it is complaining about this
one.

Ron


Important Notice!!
If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message.
Thank you.

MS Sql Server LazyDBA home page