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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Restore Replicated Database to another server

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 disk
ii) Replace current server to new server.

Your prompt response is highly appreciated."
   

- Advertisement -