Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
gtchapman
Contributor
Contributor

MSSQL Distribution Database using AlwaysOn

Need help in understanding how to set up the Distribution database using MSSQL AlwaysOn technology.

What method is used to get the Distribution database, which is a System database, onto the Secondary Replicas?

Labels (1)
1 Reply
PGN
Creator II
Creator II

The simple answer is that you configure replication on each node individually, you cannot include any system databases as a replica.  However, with AOG, it's recommended to use another server for the distribution database.  There are a number of websites that demonstrate how to set up replication  using a remote distributor for AOG nodes.  Replicate will work in either scenario, however, from personal experience, failovers are handled much more smoothly using a remote distributor.