https://community.qlik.com/t5/Qlik-Replicate/MSSQL-Distribution-Database-using-AlwaysOn/m-p/1895016#M1879 <P>Need help in understanding how to set up the Distribution database using MSSQL AlwaysOn technology.</P> <P>What method is used to get the Distribution database, which is a System database, onto the Secondary Replicas?</P> Fri, 18 Feb 2022 23:10:18 GMT gtchapman 2022-02-18T23:10:18Z https://community.qlik.com/t5/Qlik-Replicate/MSSQL-Distribution-Database-using-AlwaysOn/m-p/1895016#M1879 <P>Need help in understanding how to set up the Distribution database using MSSQL AlwaysOn technology.</P> <P>What method is used to get the Distribution database, which is a System database, onto the Secondary Replicas?</P> Fri, 18 Feb 2022 23:10:18 GMT https://community.qlik.com/t5/Qlik-Replicate/MSSQL-Distribution-Database-using-AlwaysOn/m-p/1895016#M1879 gtchapman 2022-02-18T23:10:18Z https://community.qlik.com/t5/Qlik-Replicate/MSSQL-Distribution-Database-using-AlwaysOn/m-p/1895459#M1882 <P>The simple answer is that you configure replication on each node individually, you cannot include any system databases as a replica.&nbsp; However, with AOG, it's recommended to use another server for the distribution database.&nbsp; There are a number of websites that demonstrate how to set up replication&nbsp; using a remote distributor for AOG nodes.&nbsp; Replicate will work in either scenario, however, from personal experience, failovers are handled much more smoothly using a remote distributor.</P> Mon, 21 Feb 2022 12:55:19 GMT https://community.qlik.com/t5/Qlik-Replicate/MSSQL-Distribution-Database-using-AlwaysOn/m-p/1895459#M1882 PGN 2022-02-21T12:55:19Z