Log Shipping in SQL 2000 -Connection Error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Log Shipping in SQL 2000 -Connection Error

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.
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.
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 ?
KBAhttp://support.microsoft.com/kb/314515
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>