Moving replication onto another server

Last Post 16 Jan 2008 01:05 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
APL Plus Ltd
New Member
New Member

16 Jan 2008 11:05 AM

I am trying to move merge replication onto another server. Can I just backup the pushlished database and the distribution database and reinstall them onto another server?

Also when manually recreating replication onto anther server by running the generated scripts on the other server, why do you need to drop replication before doing a backup and restore?

New Member
New Member

16 Jan 2008 01:05 PM
You may do that. Stop all outside activity first. Run all the agents. Freeze.

Move db-s.

Remap anything need of remapping.

Backup all dbs prior to starting.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: The Best SQL Server 2005 Training in the World!

Acceptable Use Policy