Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

EV DR - SQL with Logshipping

Created: 21 Aug 2013 | 1 comment
GertjanA's picture

Hello all,

I've been asked to assist in doing a DR for EV, where the SQL-server (2008) is configured to use log-shipping.

If SQL also needs to be DR tested, does anyone know/has guideline, as to how to do this? There is no experienced SQL expert available at that location. The idea is to do this in 1 day (ie goto DR, check, go back). During this, EV will be in backupmode, and all schedules will be disabled. As far as I can find, the steps would be the following:

stop logshipping. verify databases are insync. perform DR (i.e. USL, change SQL servername in registry etc). Verify Archive Explorer, Search Safe and retrieving archived items works. Archiving of items, and Journal-archiving will obviously not be tested in this scenario. Fallback to PROD again, start logshipping again, enable schedules, clear backupmode. Verify normal functionality including archiving.

Anyone has knowledge to add?

Thanks!!

Gertjan!

Operating Systems:

Comments 1 CommentJump to latest comment

A_J's picture

Hi Gertjan,

You got everything right, you may want to check from step 6 and above in the below article..

http://www.symantec.com/docs/TECH35744