Sample Header Ad - 728x90

SQL Server Replication - only ran once. How to configure scheduler from beginning

0 votes
1 answer
145 views
I have configured a transactional replication from server A to Server B some 2 month ago. The source database is a new production server, and the data is being updated there constantly. I have some issues ... I am not sure how to resolve. 1. I see that the "last sync" occurred 2 month ago, when I initially set it up. - I was expecting a snapshot job to be of a periodic nature, but it is not. - It is actually set to a "One time" and is not enabled. I know, I can "enable it" and set the schedule for the future, however I am looking for how to do it at the time when I configure the replication. I may be configuring it with the script and be expecing the configuration go into effect from the power shell script rn, and want to make sure i know how to set the schedule from the beginning. This is what I see in a schedule of a Snapshot job on the Sql Server agent. Replication Snapshot-agent job
Asked by Dmitriy Ryabin (111 rep)
May 21, 2024, 01:55 PM
Last activity: Jul 20, 2025, 06:03 AM