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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2003-03-17 : 06:24:14
|
| Gan Lee Koon writes "Dear Sir/Madam,1) If I have SQLServer 7 installed acts as Publisher. Due to hardware upgarade, what is the correct way to transfer the existing replicated database from Publisher to another new server? a)Is it I can go with backup/restore, sp_attach_db, sp_detach_db or transfer it with dts. Then, I need to reconfigure replication on new server.b) How to stop the replication service?Assumption of hardware upgrade : i) Change the higher capacity hard diskii) Replace current server to new server.Your prompt response is highly appreciated." |
|
|
|
|
|