SQL Server Performance

Log Shipping Not responding

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

  1. gautham New Member

    Hi,

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page