SQL Server Performance

Log Shipping in SQL 2000 -Connection Error

Discussion in 'SQL Server Log Shipping' started by khchaitanyaprabhu, Mar 31, 2007.

  1. khchaitanyaprabhu New Member

    Kindly share details of prerequisites for setting Log shipping in SQL 2000.
    I am facing problem when connecting to Destination server as
    "Connection could not be established,Timeout expired"
    What could be the reason and how to resolve ?
    Thank you in advance.
  2. MohammedU New Member

    Are you able to connect destination server from source server?
    Is source server service account has the access to destination server...

    Check the following articles...

    Microsoft SQL Server 2000 - How to set up log shipping (White paper)
    http://support.microsoft.com/kb/323135

    Frequently asked questions - SQL Server 2000 - Log shipping
    http://support.microsoft.com/kb/314515


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. khchaitanyaprabhu New Member

    Thank you for useful links, now i am able to establish Log shipping.
    But it is working partially.
    If i view the Log shipping pair properties it shows the status as "Secondary out of syc".
    Last backup datetime stamp is as per scheduled, but Last file copied and loaded are not according to scheduled.Last file copied and loaded shows first_file_000000000.trn.
    How to go about ?
  4. satya Moderator

Share This Page