none
Need window server restart(primary server ) impact of logshipping primary server RRS feed

  • Question

  • 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

    Thursday, December 12, 2019 6:03 AM

All replies

  • >>>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?


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Thursday, December 12, 2019 8:26 AM
  • 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


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, December 12, 2019 11:16 AM
  • 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


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, December 13, 2019 8:02 AM
  • 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


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, December 19, 2019 7:51 AM
  • 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


    ajitkumar

    Thursday, December 19, 2019 9:18 AM
  • 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

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, December 19, 2019 9:24 AM
  • 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


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, December 19, 2019 9:50 AM