Question

ajit kumar1991 on Thu, 12 Dec 2019 06:03:02


hi

I Need to window server restart(primary server ) impact of any log shipping primary server or secondary server.

any impact let me know


ajitkumar

Replies

Uri Dimant on Thu, 12 Dec 2019 08:26:11


>>>Secondary server.

this doesn't make sense. why reboot of primary would affect job schedule on secondary

>>>window server restart(primary server ) impact of any log shipping primary server

How often the backup jobs run ? Restart usually takes a few minutes , no?

Shanky_621 on Thu, 12 Dec 2019 11:16:48


hi

I Need to window server restart(primary server ) impact of any log shipping primary server or secondary server.

any impact let me know

Nothing at all. Before restarting check

1. That backup job is not running

2. Disable it before starting

After restarting enable the job.

If you are stopping the server for long time. Go ahead and disable copy and restore jobs with LS alert jobs

Amelia Gu on Fri, 13 Dec 2019 08:02:10


Hi ajitkumar,

Restarting the primary server has no effect on the primary server or secondary server.

No backup will occur if primary server is down, since remaining two jobs are on secondary server. And Log sequence number will keep up on next backup.

Hope this could help you.

Best Regards,

Amelia Gu

Amelia Gu on Thu, 19 Dec 2019 07:51:12


Hi ajitkumar,

Was your issue resolved?

If you resolved it using our solution, please kindly mark helpful replies as answers.

If you resolve it using your own solution, please share your experience and solution here. It will be very beneficial for other community members who have similar questions.

If not, please reply and tell us the current situation in order to provide further help.

Best Regards,

Amelia Gu

ajit kumar1991 on Thu, 19 Dec 2019 09:18:41


No , we are not restart the server because I need confirmation to my log shipping impact this production server &

log shipping using for reporting server.

Please confirm me no any impact of primary server & secondary  servers jobs

Shanky_621 on Thu, 19 Dec 2019 09:24:08


No , we are not restart the server because I need confirmation to my log shipping impact this production server &

log shipping using for reporting server.

Please confirm me no any impact of primary server & secondary  servers jobs

Are you posting without reading the responses ?. Please read my response

Amelia Gu on Thu, 19 Dec 2019 09:50:34


Hi ajitkumar,

If you are concerned that stopping log shipping will affect jobs on the primary and secondary servers, you could disable Backup, copy, restore jobs and LS_Alert jobs before stopping log shipping, and enable them after restarting log shipping as Shashank mentioned.

Please refer to Temporarily stop Log shipping.

Hope this could help you.

Best Regards,

Amelia Gu