Post reply

Options on publication db.

  • 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!!

  • 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
    Connect with me on LinkedIn

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

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