T-Log Growth - Replication ??

• Ray Herring

  SSCertifiable

  Points: 5533

  More actions

  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.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• Ray Herring

  SSCertifiable

  Points: 5533

  More actions

  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