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