Post reply

Stop snapshot agent?

  • February 3, 2012 at 11:40 am

    #264026

    The snapshot agent started to run a 2nd time because the schedule was not properly set. If I stop the agent will that stop replication? It is transactional, we used a backup to reinitialize the subscriber, no witness, and the distribution database is on the same server as the subscription database.

    Thanks,

    DK

  • February 3, 2012 at 12:10 pm

    #1442589

    To answer my own question, yes. Replication is still working.

    Thanks,

    DK

  • February 4, 2012 at 2:01 am

    #1442725

    DKlein (2/3/2012)

    To answer my own question, yes. Replication is still working.

    Thanks,

    DK

    🙂

    The snapshot is not needed when initialising from a backup. I would even go so far as disabling it so can manually control when its done.

  • February 5, 2012 at 9:04 pm

    #1442885

    Once a subscription has been initialised, you do not need any snapshots to be created. So, you can either disable the snapshot agent job or delete its schedule. It will only be needed if you have a need to initialise a subscription (using a snapshot, of course. If you use a database backup, the snapshot is not required)

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

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