Post reply

T-Log Growth - Replication ??

  • December 12, 2011 at 9:33 am

    #391107

    SQL 2005 (bld 4035) on Win 2003 (3790).

    My Transaction Log is growing. The T-Log backup completes but the messages include a statement that the log has not been truncated because records have not been replicated.

    I do not have replication set up for any tables in this database.

    DBCC Loginfo shows most VLFs have Status = 2 and Parity = 64. There are a few VLFs with Parity = 128.

  • December 12, 2011 at 9:45 am

    #1420160

    Please have a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

  • December 13, 2011 at 12:28 pm

    #1420823

    Thanks Gail.

    The link got me started on the right path. I ended up creating a dummy Replication Publication, running ReplDone, deleting the dummy Replication. That cleared the hung indicatorand the backup began perfroming as expected.

    Ray

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

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