0

I have configured log shipping with 20 minutes for backup, copy and restore. If i need to restart my primary server. do I need to stop all jobs (backup, copy and restore)?

Please advise.

Regards Arvind Mishra

0
0

It has happened in our case wherein we had to restart our secondary server or log shipping monitoring server as some patches were getting applied and we don't have clustering on them. Our log shipping job is configured to take backup at primary server every 15 minutes, copying and restore also at every 15 minutes however there is gap of 5 minutes in between each of them considering network latency. Only impact we had was one of the job which was scheduled during that window got skipped however no impact on log shipping as lsn number caught up itself on the next copy and restore.

Based on above experience, I don't expect any issue to happen in your log shipping even if you don't disable any jobs as the backups will not be taken if primary is down , since remaining two jobs are on secondary server. Log sequence number will catch up on next backup.

I hope this helps.

0

No you don't need to disable any job at all. Just make sure your backup job is not running at the time of restart, it may corrupt your backup in very rare case and it can disrupt your restore job eventually. No need to stop copy and restore job at all since they reside on different server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.