Sample disaster recovery configuration for SQL Server with SFW and Volume Replicator


Sample disaster recovery configuration for SQL Server with SFW and Volume Replicator
Prev	Planning your disaster recovery configuration	Next

The sample setup has four servers, two for the primary site and two for the secondary site. The nodes will form two separate clusters, one at the primary site and one at the secondary site.

The following names describe the objects created and used when configuring two sites for disaster recovery with SFW and Volume Replicator on a Microsoft cluster.

Primary Site
SYSTEM1 & SYSTEM2	server names
SQL_GROUP	Microsoft SQL Server virtual server group
SQLCLUST	Microsoft cluster
SQLVS	Microsoft SQL Server virtual server
SQL_IP	Microsoft SQL virtual server IP address resource
INST1	Microsoft SQL Server instance name
INST1_DG	disk group for Microsoft SQL volumes
INST1_SYS_FILES	volume for Microsoft SQL Server system data files
INST1_DB1_VOL	volume for storing a Microsoft SQL Server user-defined database
INST1_DB1_LOG	volume for storing a Microsoft SQL Server user-defined database log file
QUORUM_DG	quorum volume disk group for mirroring the quorum
SQL_QRM	volume for storing the Microsoft cluster quorum
Secondary Site
SYSTEM3 & SYSTEM4	first and second nodes of the secondary site
All the other parameters are the same as on the primary site.
DR Components
INST1_RDS	Volume Replicator Replicated Data Set (RDS) name
INST1_RVG	Volume Replicator Replicated Volume Group (RVG) name
INST1_REPLOG	Volume Replicator Replicator log volume
INST1_RVG_RES	Replicated Volume Group Resource name
VVR_IP	SQL RVG IP address resource