patternsqlMinor
Mirroring the Distributor
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.