EV DR - SQL with Logshipping
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?