Restore SQL Server replication subscriber



  • We have merge replication in our system and there is a case when we need to deploy our system with subscriber database and time is crutial. I wonder if the is possibility to take configured subscriber backup from working publisher-subscriber pair, restore it on other SQL Server instance without any further configuration and have two working subscribers from it. During my research I found "Allow initialization from backup files" option, but it seems to work only with transactional replication. Is there any way to achieve this something I described withe merge replication?



  • I've mostly only worked with Transactional Replication so I'm not an expert on Merge Replication, but maybe it's just a matter of taking and restoring a backup of the Subscriber database?

    Here's the docs on https://docs.microsoft.com/en-us/sql/relational-databases/replication/administration/strategies-for-backing-up-and-restoring-merge-replication?view=sql-server-ver15#backing-up-and-restoring-a-subscription-database . It doesn't sound very involved, but make sure to adhere to what it says.

    If after you restore the Subscriber database backup to another database and it doesn't automatically get picked up by the Publisher, you may need to go through the "Add Subscriber" wizard on that specific Publication (on the Publisher's server).

    I'm both cases I'd recommend also re-initializing the Snapshot for that Publication.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2