patternsqlMinor
Initialize replication sql server from backup of many databases
Viewed 0 times
databasessqlreplicationmanyserverfrominitializebackup
Problem
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?
Solution
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.
Context
StackExchange Database Administrators Q#207782, answer score: 2
Revisions (0)
No revisions yet.