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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2005-02-17 : 11:07:54
|
| HelloI copied a database to another server for testing and playing. However, that server is rubbish and takes an age to do anything, hence very limited playing. I want to move the copy back to the original server, however, will have naming conflicts. How can I overcome this?Will I have to rename all the database objects? Also, is it possible to change the name of the MDF and LDF files, as these remain the same as the original db????Hearty head pats |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-02-17 : 11:39:54
|
| Hello,Found out how to do it - detach the database and rename the files. however, I also discovered that I don't need to do that at all - I just need to export the data files - DOH! Please excuse my ignorance!Hearty head pats |
 |
|
|
|
|
|
Renaming MDF and LDF files