SKYBVI (7/28/2010)
I have a production server and a log shipping server which are acting as a primary and secondary server respectively in the log shipping setting.If I create a disaster recovery plan for my production server, what all steps should I include wrt to log shipping?
If secondary-server is off site then that's your DR platform - provided you have in place the network and security setup needed to switch your apps from Primary to Secondary site in case of a Disaster.
T-Log backup as well as log shipping have to be in line with what the company is willing to loose in case of a disaster meaning, if the company is willing to loose the last 15 minutes of activity then T-Log backups have to occur every 15 minutes and logs have to be shipped immediately to secondary site.
Last but not least, please do not forget to plan how are you going to move back from DR site to Primary site once the Disaster situation is remediated.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.