Home Forums SQL Server 2014 Administration - SQL Server 2014 Efficient way of mirroring tables from one sql instance to another RE: Efficient way of mirroring tables from one sql instance to another

  • January 24, 2018 at 5:39 am

    #1977081

    Sue_H - Tuesday, January 23, 2018 1:14 PM

    ffarouqi - Tuesday, January 23, 2018 9:39 AM

    Are there any drawbacks of having the distribution agent run every 4 hrs. instead of running continuously...log hold up etc?

    One possible consideration is the transactions would be held in the distribution database so the distribution database should support that.

    Sue

    By default, all transactions are retained in the distribution database for (I think) 30 days. (30 or 14) to allow for disconnects, new subscribers.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass