You have to change the name of the .mdf and .ldf files in the script.

-----Original Message-----
From: Smith Ron L.
[mailto:mssqldba-ezmlmshield-x74449055.[Email address protected]
Sent: Friday, April 29, 2005 6:47 AM
To: LazyDBA Discussion
Subject: Restore to different database name


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.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page