SQL Server Performance

Log Shipping Not responding

Discussion in 'SQL Server Log Shipping' started by gautham, Oct 26, 2004.

  1. gautham New Member


    I am trying to setup log shipping between 2 servers where i specify a datbase backup on the primary and then initalize this on the secondary. I ran into errors and found an article on microsoft that asked me to clean up some log_shipping tables using certain SP's. After this i started the maintenance plan all over again and it started backing up the source database to restore on the secondary. Its been over an hour and i see a NOT RESPONDING on the wizard . Please assist. How do i know if the process is still running.Thanks
  2. satya Moderator

    Under Enterprise Manager check Current activity --> Process info for details of this task.

    Ensure there are no network issues between primary and secondary SQL server and keep the service pack levels & hotfixes similar to each other.
    Refer to SQL server error log for any information.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page