Skip to main content
Tweeted twitter.com/StackDBAs/status/903922189950480384
added 105 characters in body
Source Link

I have publisher and subscriber at same server. I need to move subscriber's DB to another server but without creating new snapshot. I've tried this steps:

  • Stop all agents
  • Backup subscriber's DB
  • Restore subscriber's DB on another server with KEEP_REPLICATION
  • Changed server name in syssubscriptions, MSsubscriber_info, MSsubscriber_schedule
  • Changed server name in scheduled task for replication

Then I've started agents and got error 20053 (Server not registered). I fixed it with adding linked server to new server

After that I've got an error 20044 (Subscription is outdated or not present), but subscription is present.

What did I do wrong or maybe I have missed any step(s)?

ThanksI can't use initialization from backup, because subscriber has some additional tables, views, routines. Thanks

I have publisher and subscriber at same server. I need to move subscriber's DB to another server but without creating new snapshot. I've tried this steps:

  • Stop all agents
  • Backup subscriber's DB
  • Restore subscriber's DB on another server with KEEP_REPLICATION
  • Changed server name in syssubscriptions, MSsubscriber_info, MSsubscriber_schedule
  • Changed server name in scheduled task for replication

Then I've started agents and got error 20053 (Server not registered). I fixed it with adding linked server to new server

After that I've got an error 20044 (Subscription is outdated or not present), but subscription is present.

What did I do wrong or maybe I have missed any step(s)?

Thanks

I have publisher and subscriber at same server. I need to move subscriber's DB to another server but without creating new snapshot. I've tried this steps:

  • Stop all agents
  • Backup subscriber's DB
  • Restore subscriber's DB on another server with KEEP_REPLICATION
  • Changed server name in syssubscriptions, MSsubscriber_info, MSsubscriber_schedule
  • Changed server name in scheduled task for replication

Then I've started agents and got error 20053 (Server not registered). I fixed it with adding linked server to new server

After that I've got an error 20044 (Subscription is outdated or not present), but subscription is present.

What did I do wrong or maybe I have missed any step(s)?

I can't use initialization from backup, because subscriber has some additional tables, views, routines. Thanks

Source Link

Move transactional replication subscriber to another server without re-snapshotting

I have publisher and subscriber at same server. I need to move subscriber's DB to another server but without creating new snapshot. I've tried this steps:

  • Stop all agents
  • Backup subscriber's DB
  • Restore subscriber's DB on another server with KEEP_REPLICATION
  • Changed server name in syssubscriptions, MSsubscriber_info, MSsubscriber_schedule
  • Changed server name in scheduled task for replication

Then I've started agents and got error 20053 (Server not registered). I fixed it with adding linked server to new server

After that I've got an error 20044 (Subscription is outdated or not present), but subscription is present.

What did I do wrong or maybe I have missed any step(s)?

Thanks