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 |
|
darinh
Yak Posting Veteran
58 Posts |
 Posted - 2004-06-03 : 17:09:03
|
| Hi,I have a SQL2K database that has been installed on the same disk as the OS. I want to move it to another disk using the following proceduresp_detach_db 'databasename'copy the files from the C: Drive to the D: Drivesp_attach_db 'datebasename', 'file.mdf', 'file.ldf' etcHowever, the database I am moving is being replicated using merge replication (it is the publisher). Can I do this without first deleting the replication? If I have to delete all the pulications and then regenerate them it will take me several hours instead of a couple of minutes. BOL seems to indicate that I won't have to worry since the database is staying on the same server but it is not really clear |
|
|
|
|
|
Moving a replicated database