Post reply

If the log file is full and the replication is not in Sync, what do we need to do ?

  • May 20, 2015 at 9:40 pm

    #317615

    Hi,

    Transactional replication is configured for one DB.

    If the log file is full and the replication is not in Sync, what do we need to do ?

    Thanks in advance,

    San.

  • May 20, 2015 at 11:59 pm

    #1799542

    If log_reuse_wait_desc says it is waiting on replication and replication is getting further behind, you could re-initialize the subscription.

    Once it is in sync, you should take a log backup.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 21, 2015 at 12:31 am

    #1799545

    1) Identify why the log isn't been reused and why it's not growing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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