Transactional Replication filling up my Transaction Log

• itpcpro

  Ten Centuries

  Points: 1043

  More actions

  November 24, 2008 at 8:56 am

  #103630

  Ok.. here is my problem..

  I tried to create a Transactional Replication between SQL 2000 and SQL 2005. I could never get the Subscriber right so now I only have the Publisher on the SQL 2000 machine. I have disabled all of the jobs that I seen for replication but for some reason my Transaction Log is filling up and the only way to shrink it is by doing a sp_repldone then backing up and shrinking the Transaction Log.

  Ok here is my question?

  How do I stop the Transactional Replication from putting records in my Transaction Log so it will not fill up any more?

  Thanks

  itpcpro

• Elisabeth Rédei

  Hall of Fame

  Points: 3873

  More actions

  November 24, 2008 at 9:13 am

  #902563

  Hi,

  As long as you have Publications with articles the storage engine will mark appropriate transactions in the transaction log.

  Follow the steps in "Removing Replication " in BoL (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/fd8c59a8-b131-4c66-a86e-c916b02d149e.htm).

  HTH

  /Elisabeth

  elisabeth@sqlserverland.com
  MCITP | MCT
  http://sqlblog.com/blogs/elisabeth_redei/
  http://linkedin.com/in/elisabethredei