• Hi Neeraj,

    Thanks for your reply 🙂 I have configured a remote shared distributor and I have also setup the Principal and Mirror as publishers. On the distributor I have also done the following:

    1: Opened Distributor Properties.

    2: Opened Agent Profiles - Profile Defaults.

    3: Navigated to the Log Reader Agents.

    4: Created a New Default agent profile with the name "Failover Agent Profile".

    5: Set the -PublisherFailoverPartner Value to be the Mirror.

    I'm going to read through the link you gave me tonight when I get a chance and if I find the silly mistake I'm making I'll post it incase anyone else would find it useful 🙂

    Thanks again Neeraj! I really appreciate your help.