SQL distribution agent issues in Production

• ramana3327

  SSCoach

  Points: 19722

  More actions

  March 14, 2023 at 1:13 am

  #4160356

  Hi all,

  We have publisher, distributor & 2 separate subscribers running on different servers. The same publication is in sync with one server but error for second subscriber. Having issues with distribution to subscriber. The distribution agent is not running. It’s not providing any error messages. Changed the distribution agent priories to skip errors but still not working.It’s just retrying. No changes happened.

  Looking for suggestions. Restarted the sql agent in distributed database server.

  TIA

  • This topic was modified 2 years, 1 month ago by  ramana3327.
  • This topic was modified 2 years, 1 month ago by  ramana3327.
  • This topic was modified 2 years, 1 month ago by  ramana3327.

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  March 14, 2023 at 6:20 am

  #4160423

  Replication Monitor status?.

  Regards
  Durai Nagarajan

• March 28, 2023 at 5:05 am

  This was removed by the editor as SPAM