Merge Replication Database move to new hardware

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ponnu - 27 Dec 2006 12:16 GMT

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
Ponnu

Reply to this Message

Hilary Cotter - 27 Dec 2006 15:30 GMT

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.

Signature

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

> Hello,
>
[quoted text clipped - 9 lines]
> Best Regards
> Ponnu

Reply to this Message