snapshot agent schedule in a transactional replication

Heisenberg 261 Reputation points
2022-09-08T17:11:40.793+00:00

hello, we have newly setup a transaction replication. I see our snapshot agent job runs every hour. If i want to disable this setting of generating snapshot every hour should i just disable the schedule or is there any other setting for this?

Also when snapshot agent runs every hour does it create new snapshot each time or it only creates snapshot with new changes that have been done since the last snapshot (incremental way). Thank you

SQL Server | Other
{count} votes

Accepted answer
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2022-09-09T06:33:31.707+00:00

    Hi @Heisenberg ,

    As Tom mentioned that snapshot agent is only used for first time initialization and if new articles are added and need initialization. So this job does not need to be scheduled to run every hour. You can change this follow below steps.

    239367-capture.png

    239355-capture1.png

    239368-capture2.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    1 person found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Tom Phillips 17,771 Reputation points
    2022-09-08T17:26:15.953+00:00

    Snapshot agent is only used for first time initialization and if new articles are added and need initialization. It does not do anything if there is not new articles added.

    0 comments No comments

  2. Heisenberg 261 Reputation points
    2022-09-08T21:21:27.707+00:00

    i agree, but i see the snapshot agent job is scheduled to run every hour in my environment why would it be and how can i change it?

    0 comments No comments

  3. Heisenberg 261 Reputation points
    2022-09-20T23:49:28.51+00:00

    Thank you @CathyJi-MSFT

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.