Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.