November 2, 2022 at 12:45 am
Hi,
I have a SQL 2019 server that is currently running replication. However I want to only run it between certain hours, ie not between 21:00 and 5:00. I have read the the Microsoft link https://learn.microsoft.com/en-us/sql/relational-databases/replication/specify-synchronization-schedules?view=sql-server-ver16 but either I'm reading it wrong or I'm missing a step. Step 4 instructions don't seem to be right there is no "Action" option.
Can someone please help me setup scheduling. I believe it would have been easier in setup but I wasn't here for that.
Kris
November 3, 2022 at 1:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
November 3, 2022 at 6:50 am
What section and step within the documentation are you at ? Is this transactional replication ? Is it push or pull subscription ? Where is the distributor ?
----------------------------------------------------
November 8, 2022 at 1:13 am
It's transactional push replication. The distributor is on on the publisher. I got to step 6 of To modify a synchronization schedule for a push subscription in Replication Monitor. I can find the scheduler but I can't see how I can run the agent only between 5am and 9pm.
Kris
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply