Metafile allocation, Metafile allocation (in a cluster configuration), Using a cluster configuration – HP XP P9000 Command View Advanced Edition Software User Manual
Page 396
Figure 16 Metafile allocation
If the database server is in a cluster configuration using Microsoft Cluster Service and metafiles are
stored in a storage system volume, a secondary volume can be used to restore the metafiles when the
cluster server fails over.
For best results, store metafiles in a volume belonging to an SQL Server resource group so that, even
if an SQL Server cluster resource fails over, the metafiles are failed over with the resource group.
The following figure shows a sample location for metafiles in an active/standby (or active/passive)
cluster configuration.
Figure 17 Metafile allocation (in a cluster configuration)
Using a cluster configuration
Do not register the service resources of multiple SQL Server instances into a single cluster group.
Managing application replicas
396