I need to move an SQL 7 database to an SQL 2005 server that already has a database with the same name. The SQL 7 database needs to have a new name and not affect in any way the one that's already on the 2005. How can I do this? Do
I need to rename the 7 database before I back it up, and if so, how do I do this so everything (log files, etc) reflect the new name so nothing crushes anything on the 2005?
View Complete Post