1. Bring PROD offline (set maintenance flag to 1 in Web.config of prod front end)
2. Disable LogShipping Jobs for PROD DB
3. Do a ‘Select count(*)’ on ActivityLogDeNorm and OutputBuild tables
4. Disable LogShipping Jobs for QA DB
5. Bring vtxml_disaster_recovery DB out of StandyMode by running the following script:
USE master
RESTORE DATABASE vtxml_disaster_recovery WITH RECOVERY
GO
6. Delete vtxml_user and re-add to vtxml_disaster_recovery DB
7. Bring DR Site online (set maintenance flag to 0 in Web.config of vtxml_disaster_recovery front end)
The remaining steps take about an hour because of the copying back and forth of big db bak files.8. Run Backup of DR DB with BackUp Script (located in projects folder on QA DB)
9. WinZip DR DB backup and copy to Prod S Drive
10. Delete LogShipping Records on both S Drives
11. Restore DR DB backup to PROD using Restore Script. Delete PROD db first.
12. Then do MANUAL backup of PROD DB and WinZip it and copy back to QA.
13. Unzip PRODDB.zip on QA and MANUALLY restore to vtxml_disaster_recovery with StandBy On. Overwrite existing... See attached pic:
14. Go back to PROD and enable LogShipping Jobs and start them at first step
15. Do same on QA and verify the work successfully.
16. Bring PROD online (set maintenance flag to 0 in Web.config of prod front end)