Tasks for configuring the secondary site for disaster recovery for SQL Server


Tasks for configuring the secondary site for disaster recovery for SQL Server
Prev	Configuring disaster recovery	Next

After creating a high-availability Microsoft cluster with SFW and SQL Server on a primary site, you can configure a secondary site for disaster recovery.

This disaster recovery solution requires Volume Replicator.

Refer to the Volume Replicator Administrator's Guide for additional details.

The following table describes the process for configuring the secondary site for disaster recovery.

Table: Process for configuring the secondary site for disaster recovery

Action

Description

Verify the primary site configuration.

See Verifying the primary site configuration.

Review the prerequisites and planning information

Verify the prerequisites on the secondary site.

See InfoScale requirements for Microsoft clustering solutions.

Note:

If the DR site is on a different network segment, ensure that you allocate two IP addresses for the virtual server, one for the primary site and one for the DR site.

Understand the DR configuration.

See Planning your disaster recovery configuration.

Create the parallel configuration on the secondary site

Ensure that you follow the secondary site requirements and guidelines for IP addresses, disk groups and volumes, the SQL Server resource group, and SQL Server installation.

See Creating a parallel environment for SQL Server on the secondary site.

Understand the Volume Replicator components

See Volume Replicator components overview.

Set up security for Volume Replicator

Set up the security for Volume Replicator on all nodes on both the primary and secondary sites.

See Setting up security for Volume Replicator.

Create the cluster resources for Volume Replicator

Create an IP address for the Replicated Volume Group (RVG).
Create a Network Name resource for the Replicated Volume Group (RVG).

See Creating resources for Volume Replicator.

Set up an RDS

Create a replicated data set (RDS) using the Volume Replicator wizard.

See Configuring Volume Replicator: Setting up an RDS.

Create the RVG resource (primary and secondary sites)

Create the RVG resource on both primary and secondary sites.

See Creating the RVG resource.

Set up the SQL Server resource dependencies

Change the SQL Server resource dependency properties so that it depends on the RVG resource instead of the Volume Manager Disk Group resource.

See Setting the SQL server resource dependency on the RVG resource.