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 ?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!