Merge Replication Database move to new hardware -- sql server replication

ponnu
12/27/2006 4:16:01 AM

Hello,

How to move 50GB of Publication Database to new Hardware( New SQL Server)
quickly without loosing replication inforamtion.

Replication Type : Merge
OS : Windows 2003 Server
SQL Version : SQL Server 2000
Edition : Standard
Service Pack : SP4

Best Regards

Hilary Cotter
12/27/2006 10:30:45 AM

This can't easily be done. You are best off to rename the new SQL Server
with the name of the existing SQL Server and then restore the master, msdb,
distribution, and published databases on to the new server.

If this can't be done you will have to script out the publications and
subscriptions, drop them in current production and redeploy them on the new
server editing the scripts for the new SQL Server name.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : Merge Replication Database move to new hardware