CODEWITHSUNDEEP
sql-serverdatabaselog-shipping
Rahul Khanna
Rahul Khanna

Reputation: 137

Any impact of changing SQL Server log shipping restore job schedule

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?

Upvotes: 0

Views: 381

Answers (1)

Rahul Khanna
Rahul Khanna

Reputation: 137

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.

Upvotes: 0

Related Questions