Site Recovery is an Azure service that contributes to your strategy for business continuity and disaster recovery by orchestrating the replication of on-premises physical servers and VMs to the cloud (Azure) or to a secondary datacenter.
When outages occur in your primary location, you fail over to the secondary location to keep applications and workloads available.
WSUS servers can be configured to use Windows® Internal Database, the database software that is included with WSUS, or the full version of SQL Server.
Regardless of which database option the source server is running, perform the following procedures to back up the WSUS database on the source server and restore the database to the destination server.
You fail back to your primary location when it returns to normal operation.
Site Recovery provides test failovers to support disaster recovery drills without affecting production environments.
Azure Premium Storage delivers high-performance, low-latency disk support for virtual machines (VMs) that are running I/O-intensive workloads.
If the source server is a domain member server, and the destination server is a domain controller: Imported local users are elevated to domain users, and imported local groups become Domain Local groups on the destination server.
For an overview of backup and command-line syntax, see the following articles on SQL Server Tech Center: SQL Server Management Studio must be run with elevated administrator permissions throughout this guide.
To run SQL Server Management Studio with elevated administrator permissions in Windows Server 2008 and Windows Server 2008 R2, click Start, point to All Programs, point to SQL Server 2005 or SQL Server 2008, right-click SQL Server Management Studio, and then click Run As Administrator.
When a database is restored to a different server, it contains a set of users and permissions, although there may be no corresponding logins, or the logins may not be associated with the same users.
This condition is known as having "orphaned users." See Microsoft Support article Troubleshooting Orphaned Users Topic in Books Online for instructions on resolving orphaned users.