The following figure shows an example configuration of the disk groups and volumes for SQL Server on the primary site of a Microsoft cluster disaster recovery configuration.
Figure: SFW disk groups and volumes for SQL virtual server in a Microsoft disaster recovery configuration
Warning: |
When configuring the disk groups and volumes on the secondary site, be sure to use the same disk group and volume names as on the primary site. |
SQL disk group INST1_DG contains at least the following volumes:
INST1_DB1_VOL contains the SQL database. Each database typically resides on a separate volume.
INST1_DB1_LOG contains the transaction log.
INST1_SYS_FILES contains the volume for Microsoft SQL Server system data files.
INST1_REPLOG contains the replicator log for Volume Replicator.
If FILESTREAM is implemented, the configuration should also contain a separate volume for the FILESTREAM filegroup.