Bring the DR system back to DR mode after a real disaster

Build 1501 on 14/Nov/2017  This topic last edited on: 7/Nov/2014, at 17:18

If the DR system was brought online because of a real disaster, this section describes how it is brought back to the original Disaster Recovery mode. In a nutshell it involves:

1. Re-enable the two SQL Server Agent jobs on the DR system.

2. Once the live system is fully restored and operating normally, make a full backup of the live database and restore it on the DR system.

3. Re-enable the two SQL Server Agent jobs on the DR system, which were disabled.

They should be enabled one of a time. Once the "LSCopy" job has finished the first iteration successfully (might take up to 20 minutes depending on how long the DR system was online), the "LSRestore" job should be enabled.

The "LSRestore" job takes quite a while to finish. It restores each individual transaction log backup file since the full backup was taken and each of them can take about 30-40 seconds to complete. If you do this in the late afternoon / evening, it can take couple of hours to finish.