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

Mirroring the Distributor

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thedistributormirroring

Problem

Has anyone had success with mirroring the distribution database? We have a dedicated server as a Distributor. It handles all our push replication from prod to reporting. We'd like to build an identical server, close by, in case the distributor crashes. Has anyone had success building something like this?

Solution

Sadly mirroring of the distributor isn't supported. I'm not sure if it would work as the server names wouldn't be correct when the agents would log in, not to mention you'd have to manually setup all the agents on the backup box. Currently your only HA option for the distributor is Windows Clustering.

Context

StackExchange Database Administrators Q#6549, answer score: 7

Revisions (0)

No revisions yet.