Post reply

How to schedule transaction replication in sql server

  • January 21, 2015 at 6:18 pm

    #397912

    Hi There,

    I wanted to schedule the transaction replication. How do I do it? Currently I have set up a transaction replication which runs continuously and synchronizes the changes with immediate effect.

    I need to configure a replication which will gather logs from the publication once in a day.

    Is there any possibility?

    Thanks in advance

  • January 21, 2015 at 10:39 pm

    #1772058

    You can update both the log reader agent job step and distrubution agent job steps by removing the "-Continuous" flag and add "-PollingInterval 86400".

    86400 seconds is 24 hours.

    However your published database log file will grow throughout the day until the log reader agent marks the log records as replicated.

    You should probably either run the log reader continuously or frequently and then set the distribution agent to 24 hours, if your aim is to have a replicated database 24 hours behind the publication.

  • January 21, 2015 at 11:03 pm

    #1772059

    Andrew G (1/21/2015)

    You should probably either run the log reader continuously or frequently and then set the distribution agent to 24 hours, if your aim is to have a replicated database 24 hours behind the publication.

    I got your point, this is what I exactly needed. But where do I change these settings? how do I find those jobs?

  • January 21, 2015 at 11:43 pm

    #1772062

    The log reader agent job will be running on the published db server as a SQL Agent Job. By default it is named in the format of ServerName-PublicationName-Number.

    Eg. Myserver\testInstance-AdventureWorks-2

    Depending if you have a Push or Pull subscription, the distribution agent job will be on either the publisher or subscriber server with a similar name by default.

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

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