Options on publication db.

• Paul Kelsey

  SSC Veteran

  Points: 293

  More actions

  October 3, 2002 at 1:43 pm

  #158783

  Considering how vital the interaction between the log reader agent and the publication db's log file is, is it a bad practice to have the "auto shrink" option turned on in the publication db? (SQL Server 2000 with transactional replication.)

  Will it cause unwanted log truncation?

  Thanks again!!

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 3, 2002 at 2:18 pm

  #437791

  Wont hurt anything..in the log anyway! Transaction cant be removed until processed by the logreader. This true even for local things that dont get replicated like index rebuilds that generate log entries.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter