Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamalis14
Starting Member
1 Post |
 Posted - 2008-05-29 : 14:49:43
|
| We have 2 versions of an application that reside on 2 different servers. We are retiring one of the servers and I need to move the db of the old version of the app onto the new server. The problem I am running into is that both dbs have the exact same names. Could I just rename the db,data file and log file on the old server; copy the mdf and ldf to the new server and attach it as a different db? Does it make more sense to do it like that then trying to use one of the backups and restore it since of the similar names or should rename the files, make a new backup, and restore to a new db? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-29 : 15:35:44
|
| When you perform the restore, provide a new database name and either different file names or use a different path.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
|
|
|
move a db to new server