question

MarkGordon-2676 avatar image
0 Votes"
MarkGordon-2676 asked MarkGordon-2676 commented

Moving Replication

Fellow DBAs
We are in the process of rebuilding existing instances to new node.
So, in the end, the new nodes will have the same instance name etc.

But we have some dbs with replication - it is PULL approach.

The pub and sub dbs will be dettached from existing box and reattached to the new box.

I know that when the new instances are built, sql agent jobs are gone which includes the replication created agent jobs.

Does the distribuotr have to be dettache and reattached along with the move or will just backing up (scripting out) the replication objects and restoring them via script take care of all of that?

thx

MG



sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered MarkGordon-2676 commented

Hi MarkGordon-2676,

Does the distributor have to be detach and reattached along with the move or will just backing up (scripting out) the replication objects and restoring them via script take care of all of that?

You need to script or backup the distribution database at the Distributor to new node. You can script all replication objects by right-clicking the Replication folder-> Generate Scripts in publications, subscriptions and distributor server.

84862-01.jpg

Please refer to Moving Distribution Database – step-by-step guide and Generate SQL Script (Replication Objects) which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



01.jpg (223.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.