Replicated transactions are waiting for next Log backup or for mirroring partner to catch up. RRS feed

  • Question

  • This commonly seen message on forum has been coming in my env too. 

    When the networks guy fixes the issues with the networks, the issue resolves. However, I want to configure replication to not to be impacted by mirroring. 
    Have already tried the following but still no go:

    trace flag -T1488
    sp_replicationdboption 'ProblemDatabaseName','sync with backup',false

    Is there anything else that can be done to break the association between the mirroring and replication to ensure that evenif mirroring isbehind, it doesnot break replication. 

    • Moved by Kalman Toth Wednesday, September 10, 2014 12:05 AM Not T-SQL
    Tuesday, September 9, 2014 5:07 AM


All replies