Post reply

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

  • June 19, 2012 at 5:39 am

    #392552

    I have SQL Server 2008 transactional replication for 21 locations.No Mirroring is configured on this server for any database yet I am getting the error:

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

    Due to this without taking log backup the the log reader shows this above error and replication is not continued

    Thanks

  • June 19, 2012 at 5:55 am

    #1502748

    Does the system table below show entry of some old mirroring set up which was removed later

    select * from sys.database_mirroring

    If this is has some entries of mirrored database please break the mirroring if you are not using it.

    Cheer Satish 🙂

  • June 19, 2012 at 6:02 am

    #1502754

    I have checked from GUI and :

    Select * from sys.database_mirroring_endpoints;

    and find nothing.

    That server is never used for mirroring also.

    It is production and needs lots of approval for any change.

    Thanks

  • June 22, 2012 at 1:03 am

    #1504352

    Hi,

    After enabling trace 1448 the issue has not resolved.

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply