HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Initialize replication sql server from backup of many databases

Submitted by: @import:stackexchange-dba··
0
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.