Post reply

Transactional Replication and Trans Log backups

  • February 12, 2006 at 3:59 pm

    #110977

    From BooksOnLine --The transaction log of a published database might require more space than the log of an identical unpublished database, because the log records are not truncated until they have been moved to the distribution database.---

    What happens when there is a job to backup the transaction log of the Publisher at fixed intervals?

    Thanks.

  • February 12, 2006 at 5:02 pm

    #620345

    I just found answer for SQL Server 2005:

    Set both PUBLICATION and DISTRIBUTOR databases SYNC WITH BACKUP

    However, can this be implemented in SQL Server 2000?

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

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