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 |
|
rwaldron
Posting Yak Master
131 Posts |
 Posted - 2008-08-05 : 18:31:22
|
| Hi all,I have a DB called Extranet in SQL 2000 on one server.I have a DB Called Extranet in SQL 2005 on another server.I want to import Extranet in sql 2000 to SQL 2005 Server but NOT with the name Extranet as this already exists.So I am basically trying to detach an SQL 2000 DB and re-attaching to SQL 2005 but with a DIFFERENT Name to Extranet as this already exists...Everything I try says DB Extranet already exists.I have tried copy DB in SQL 2005 and Restore DB..The Logical Name ( Extranet) I don't seem to be able to change.Can some one help me Detach and re-attach as a different DB Name Ray.. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-05 : 18:39:17
|
| Can you use Backup/Restore instead? |
 |
|
|
rwaldron
Posting Yak Master
131 Posts |
Posted - 2008-08-05 : 19:53:04
|
| Hiya,I got it to work byDetaching on sql2000.Copying MDF and LDFRenaming these files.attach these new files to SQL 2005 as a newly named DB |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-05 : 20:07:41
|
| But that is risky.Always make sure you backup your database before you do that. |
|
|
|
|
|
|
Detach / rename / attach from 2000 to 2005