Restoring Production from a Warm Backup
If the source system becomes unreliable, it is possible to restore the databases from the destination to the source. Perform the following procedure to restore databases from the destination to the source.
To restore the databases from the destination to the source follow these steps
Disable all backup jobs on the source (production) SQL Server instance(s).
Wait for all restore jobs to complete on the destination disaster recovery (DR) SQL Server instance(s).
Disable all restore jobs on the destination (DR) SQL Server instance(s).
Restore all databases with STOPATMARK on the destination (DR) SQL Server instance(s).
Stop all BizTalk Server services on all BizTalk servers.
Drop all BizTalk Server-related databases on the source (production) SQL Server instance(s).
Back up (full) all databases on the destination (DR) SQL Server instance(s).
Restore (full) all BizTalk Server databases backed up in step 7 to the source (production) SQL Server instance(s).
Restart all BizTalk servers including the master secret server.
Drop all BizTalk Server-related databases on the destination (DR) SQL Server instance(s).
Enable backup jobs on the source SQL Server instance(s).
Enable restore jobs on the destination (DR) SQL Server instance(s).