Sample high availability configuration for SQL Server with SFW


Sample high availability configuration for SQL Server with SFW
Prev	Planning your SQL Server high availability configuration	Next

The example configuration includes the dynamic mirrored quorum and requires setting up two or more dynamic cluster disk groups in SFW - one or more cluster disk groups for the application and data and one for the dynamic mirrored quorum.

The following names describe the objects created and used during the installation and configuration.

Name	Object
SYSTEM1 & SYSTEM2	server names
SQL_GROUP	Microsoft SQL Server resource group
SQLCLUST	Microsoft cluster for SQL Server high availability
SQLVS	Microsoft SQL Server virtual server
INST1	Microsoft SQL Server instance name
INST1_DG	disk group for Microsoft SQL Server 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	disk group for quorum volume
SQL_QRM	volume for storing the Microsoft cluster quorum

More information is available on disk group and volume configuration.