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?


1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.