March 11, 2017 at 12:48 pm
Hi,
We need to replicate 3 DBs like this, using sql transactional replication 2.way:
Server=2 (active); Database=DBco <-> Server=1 (passive); Database=DBco
Server=2 (active); Database=DBhist <-> Server=1 (passive); Database=DBhist
Server=2 (active); Database=DBco <-> Server=3 (passive); Database=DBco
Server=2 (active); Database=DBhist <-> Server=3 (passive); Database=DBhist
Server=2 (active); Database=DBca <-> Server=1 (passive); Database=DBca
At the end:
Server 2 has: 5 publications, 5 push subscriptions.
Server 1 has: 3 publications, 3 push subscriptions
Server 3 has: 2 publications, 2 push subscriptions
It works correctly but we needed to start the whole replication from scratch by disabling publishers and distributors on the 3 servers yesterday.
We are trying to set it up again (we initialize them from backup via scripts not GUI), but every time we restore a BAK file we see subscriptions generated automatically as if it came with the BAK file. It had never happened before. Thus we are getting errors that say "can't add this because it already exists", and if we try to delete it it says "cannot delete as it doesn't exist".
What could be going on?
Thanks in advance
March 11, 2017 at 12:49 pm
Sorry, the subject is confusing.
We want to know what is going on, and also if you think our replication topology is correct?
All 3 DB servers are distsributors, publishers and subscribers.
Regards
March 12, 2017 at 12:12 am
nevermind, we were restoring the database with keep_replication setting
unchecking it solved everything
March 13, 2017 at 5:16 am
rogelio.vidaurri - Saturday, March 11, 2017 12:48 PMHi,We need to replicate 3 DBs like this, using sql transactional replication 2.way:
Server=2 (active); Database=DBco <-> Server=1 (passive); Database=DBco
Server=2 (active); Database=DBhist <-> Server=1 (passive); Database=DBhist
Server=2 (active); Database=DBco <-> Server=3 (passive); Database=DBco
Server=2 (active); Database=DBhist <-> Server=3 (passive); Database=DBhist
Server=2 (active); Database=DBca <-> Server=1 (passive); Database=DBcaAt the end:
Server 2 has: 5 publications, 5 push subscriptions.
Server 1 has: 3 publications, 3 push subscriptions
Server 3 has: 2 publications, 2 push subscriptionsIt works correctly but we needed to start the whole replication from scratch by disabling publishers and distributors on the 3 servers yesterday.
We are trying to set it up again (we initialize them from backup via scripts not GUI), but every time we restore a BAK file we see subscriptions generated automatically as if it came with the BAK file. It had never happened before. Thus we are getting errors that say "can't add this because it already exists", and if we try to delete it it says "cannot delete as it doesn't exist".What could be going on?
Thanks in advance
If you're replicating a complete copy of a database then replication is probably the last option you want to use
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2017 at 8:35 am
Perry Whittle - Monday, March 13, 2017 5:16 AMrogelio.vidaurri - Saturday, March 11, 2017 12:48 PMHi,We need to replicate 3 DBs like this, using sql transactional replication 2.way:
Server=2 (active); Database=DBco <-> Server=1 (passive); Database=DBco
Server=2 (active); Database=DBhist <-> Server=1 (passive); Database=DBhist
Server=2 (active); Database=DBco <-> Server=3 (passive); Database=DBco
Server=2 (active); Database=DBhist <-> Server=3 (passive); Database=DBhist
Server=2 (active); Database=DBca <-> Server=1 (passive); Database=DBcaAt the end:
Server 2 has: 5 publications, 5 push subscriptions.
Server 1 has: 3 publications, 3 push subscriptions
Server 3 has: 2 publications, 2 push subscriptionsIt works correctly but we needed to start the whole replication from scratch by disabling publishers and distributors on the 3 servers yesterday.
We are trying to set it up again (we initialize them from backup via scripts not GUI), but every time we restore a BAK file we see subscriptions generated automatically as if it came with the BAK file. It had never happened before. Thus we are getting errors that say "can't add this because it already exists", and if we try to delete it it says "cannot delete as it doesn't exist".What could be going on?
Thanks in advance
If you're replicating a complete copy of a database then replication is probably the last option you want to use
just articles, not a complete copy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply