On the SQL Server log shipping secondary database server, I have 2 jobs LS_Copy and LS_Restore.
Current schedule: both jobs run every 30 minutes (all day)
New schedule: I want to change the restore job to run every 30 minutes between 10:00 AM to 7:00 PM and 6:30 AM to 7:30 AM. It won't be running for the remainder of the day.
The copy job will still have the same schedule, i.e., every 30 minutes (all day)
Question: do you know if making this change can create issues I am unaware of?
I modified the schedule to new one, everything is working fine. The copy job piles up the files and whenever restore executes, it processes all the queued files in correct order.