Post reply

Does db have to be in Full Mode for Trans Replication?

  • June 6, 2005 at 8:26 am

    #89384

    Hi replication gurus,

    I am reading Alexander Chigrik's article on replication,

    http://www.mssqlcity.com/Articles/Replic/troubleshooting_replication.htm

    which states the following:

    6. Check that 'trunc. log on chkpt' option is turned off, if you want to set up Transactional replication.

    Transactional replication uses the transaction log to capture changes that were made to data and then sent to Subscribers the INSERT, UPDATE, and DELETE statements in the same order that were made in the Publication database.

    -------------

    I don't undestand why this is so, this is not Log shipping. Each transaction will be delivered immidiately, so it seems like database could be in Simple mode. Can someone clarify, is Alexander correct?

    Thanks

     

     

     

  • June 7, 2005 at 3:55 am

    #563433

    He's wrong. It can be in any mode. I think he is making this recommendation to maintain the size of the log file.

    Ideally you want the log file to be as small as possible. I run in full mode and dump it every 5 minutes.

    --

    Hilary Cotter

    Looking for a SQL Server replication book?

    http://www.nwsu.com/0974973602.html

    Looking for a FAQ on Indexing Services/SQL FTS

    http://www.indexserverfaq.com

     

  • June 7, 2005 at 11:23 am

    #563616

    You want the log to be small in order not to stress the log reader agent, is that it?

     

    Thanks

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

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