Post reply

transaction replication?

  • June 2, 2008 at 11:57 am

    #188497

    hi,

    I have a general question.If database A is replicated database B using transaction replication. How long Database A can hold the data without sending the data to Database B?

  • June 2, 2008 at 12:56 pm

    #823218

    As long as it gets replicated to ServerB...

    For disconnected servers...it is advisable to use merge replication...

    MohammedU
    Microsoft SQL Server MVP

  • June 2, 2008 at 1:39 pm

    #823259

    thank you

  • June 3, 2008 at 9:10 am

    #823691

    madhu.arda (6/2/2008)

    hi,

    I have a general question.If database A is replicated database B using transaction replication. How long Database A can hold the data without sending the data to Database B?

    That is a configurable Distributor Property called: Transaction Retention Period.

    By default up to 72hrs


    * Noel

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

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