SQL Server Performance

Log shipping hangs on setup.

Discussion in 'SQL Server Log Shipping' started by cordinvi, May 10, 2004.

  1. cordinvi New Member

    Hi all,

    I am trying to set up log shipping bewteen 2 SQL 2000 SP3a servers. The maintenance plan wizard does the backup of the primary server database but then hangs after that. I get the 'Application not responding error' in task manager.

    I am using the same domain account (a trust has been set up between the 2 domains) with local admin on both servers to run all services. I have done a transfer logins job using the same login account, and needless to say I can't find anything on the Microsoft site.

    Any help would be very much appreciated.

    Many thanks


  2. satya Moderator

    Try to reconfigure the log shipping from scratch again and individual plan for each database.
    Check SQLAgent error log for more information on the job failure and all the logs from event viewer & sql server.

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

    Many thanks,

    I have just discovered the trust between the 2 domains was only a 1 way trust so problem sorted out.


Share This Page