-
Notifications
You must be signed in to change notification settings - Fork 10
Cluster Disk Configuration
Previous Cluster IP Address Allocation | SSIS Cluster Guidelines Next |
---|
The Windows cluster must be configured with all the disk resources that will be used during the SQL Server Cluster install. The following disk resources will be used by FineBuild. The disk resource names will be changed to match the disk volume labels assigned by FineBuild.
It is recommended that you use Cluster Shared Volumes (CSVs) where these are allowed by the Microsoft SQL Install. You can use CSVs on Windows 2012 and above for SQL Server data, log and backup files, but not for Full Text data. CSVs are not valid for Analysis Services.
In the table below, the drive letters assigned to the /Vol... parameters for a given cluster must not be the same as the drive letters assigned to a different cluster. Within a given cluster, a given drive letter can be used multiple times. For example, the same drive letter can be assigned to both /VolData: and /VolDataFT:, but this drive letter must not also be assigned to /VolDataAS:.
Cluster | /Vol... parameter | Default label |
---|---|---|
SQL DB | /VolData: | SQL Data |
/VolDataFS: | FS vData | |
/VolDataFT: | FT Data | |
/VolTemp: | SQL Temp | |
/VolLog: | SQL Logs | |
/VolLogTemp: | Temp Logs | |
/VolBackup: | Backup | |
SQL AS | /VolDataAS: | AS Data |
/VolLogAS: | AS Logs | |
/VolTempAS: | AS Temp | |
/VolBackupAS: | AS Backup | |
SQL IS | No /Vol... parameters used | |
MSDTC | /VolDTC: | MSDTC |
The following /Vol... parameters are also used in a SQL Server cluster install, but must be set to use a drive that is not a cluster resource because they must be local to each node:
/VolProg: /VolBPE: /VolTempWin: Please see Vol Parameters and Setup Drive Labels for more details of drive parameters and labels.
The SQL Server client tools will always be installed on the System drive for a cluster install. This is because:
-
The Microsoft SQL Server install process does not allow these files to be placed elsewhere when a node is added to an existing SQL Server cluster.
-
It is best practice for all servers in a cluster to use the same file locations.
Copyright FineBuild Team © 2014 - 2018. License and Acknowledgements
Previous Cluster IP Address Allocation | Top | SSIS Cluster Guidelines Next |
---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP