Post reply

Snapshot agent scheduling

  • April 4, 2011 at 9:41 am

    #237934

    About how often should I schedule a snapshot agent to run when I'd prefer to wait as long as possible? Reason being, the agent take 4 plus hours to complete, a price I have a hard time paying.

    Thanks in advance,

    DK

  • April 4, 2011 at 9:27 pm

    #1307271

    If you are using a Snapshot Publication - then as aften as you need.

    If you are using any other type of publication, you only need to run the snapshot agent when you need to intialise part or all of a publication.

    If all of your subscribers are ticking away nicely, you may not need to run the snapshot agent at all.

  • April 5, 2011 at 10:31 am

    #1307577

    Thanks happycat59,

    It is transactional, and it is ticking away happily.

    Thanks again,

    DK

  • April 12, 2011 at 1:48 am

    #1310241

    You only need to do it when you have made changes to the publication. Any other time is redundant.

    If you've made changes to the publication correctly by script, the snapshot will only include the article changes and will not take long to generate.

    The only time a full snapshot should be generated is if you add a new subscriber.

  • April 12, 2011 at 1:50 am

    #1310242

    I should also point out, that you can get around the full snapshot by adding the subscription to the new subscriber a @syncronisation_type (?) = 'none' and restoring a full backup of another subscriber with KEEP REPLICATION.

    You will need to stop the log reader agent before hand and ensure all commands have been delivered.

  • April 12, 2011 at 7:15 am

    #1310362

    Thanks for the replies MysteryJimbo,

    Those are helpful.

    DK

Viewing 6 posts - 1 through 5 (of 5 total)

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