I want to know how I can initialize a subscription from a backup of a publication database. I have three diferent databases that will point to the same subscriber. For the first time there is no problem but the second and the third one I have problems. How can I initialize the suscription without lossing the data from the first time and the data from the other two db integrate to the first?
Sql-server – Initialize replication sql server from backup of many databases
replicationsql servertransactional-replication
Related Question
- SQL Server Replication – Initialize from Multiple Split Backup Files
- SQL Server Replication – Initialize with Snapshot Using Filtered Rows
- SQL Server Replication – How to Find and Drop Subscriptions
- Sql-server – SQL Server Database Restore with Replication
- How to Initialize Transactional Replication from Backup at URL – Azure Blob Storage
- SQL Server 2016 – Transactional Replication Reports OK but Tracer Token Not Arriving
- Sql-server – Transaction Replication:Intialize from Backup
Best Answer
You can't do that. Initializing from a backup is only appropriate when you want to overwrite the subscriber database. In your scenario you should probably use regular snapshot initialization, so each subscription will create and load its own tables.