Home > IT Answers > SQL Server > SQL Server 2005 Log Shipping question
Lorelei
10 pts.
Q:
SQL Server 2005 Log Shipping question
SQL Server 2005, SQL Server 2000 Log Shipping, SQL Server log shipping, Log Shipping
I have setup log shipping on our production SQLServer to send the logs to a server I have at my home for a warm backup solution. The process seemed to work but then I had a problem on my secondary server - it seemd to stop working for a period of 2 weeks (I dont know why - I could not login to it and had to power it off to reset it)and I didnt notice until I did a random check. My question is will log shipping survive if the receiving server goes off line for 2 weeks ? When I bring it back on line does it go and collect all the logs it hasnt yet seen and RESTORE them correctly ? The reason I ask is because I am now seeing errors saying "cannot be restored due to a "gap in the log chain" how do I solve this issue ?

Software/Hardware used:
SQL Server 2005
ASKED: Nov 30 2009  9:27 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
Mrdenny
49385 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
It will survive short gaps. The length of time it will survive is controlled by the amount of time the system keeps the transaction logs on the primary servers hard drive. Once they are deleted from there they are gone.

You'll need to do a full backup and restore it to the backup machine then the log shipping can work again.
Last Answered: Nov 30 2009  11:04 PM GMT by Mrdenny   49385 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _