About configuring SQL Server in physical environment
You can configure SQL Server in a physical environment following five simple steps:
-
Manage storage
-
Install InfoScale Availability
-
Install SQL Server
-
Configure VCS cluster
-
Configure SQL Server service group
The following table provides the workflow for installing and configuring SQL Server in VCS environment, involving physical systems.
Related information
Table: Installing and configuring SQL Server in a VCS environment on physical systems or virtual machines involving shared or non-shared storage
| Task | Details |
|---|---|
| Manage storage | Depending on the type of storage used, perform the steps to manage it for VCS cluster configuration\: |
| - Shared storage employing NetApp filers over an iSCSI or Fibre Channel (FC) connection and NetApp SnapMirror for replication See Table: Installing and configuring SQL Server in a VCS environment on physical systems or virtual machines involving shared or non-shared storage .See Managing storage using NetApp filer . | |
| - Shared or non-shared storage managed using Windows Logical Disk Manager See Managing storage using Windows Logical Disk Manager . | |
| Install InfoScale Availability | Install InfoScale Availability on all the systems where you want to configure |
| the application. | |
| See About installing the VCS agents . | |
| Install SQL Server | See About installing SQL Server for a high availability (HA) configuration . |
| Configure VCS Cluster | Set up the components required to configure the cluster and the cluster service group. |
| See Configuring the cluster using the Cluster Configuration Wizard . | |
| Configure SQL Server service group | Configure the SQL Server service group to create resources for the |
| storage and application agents. | |
| See About configuring the SQL Server service group . | |
| For configuring an MSDTC service group: | |
| See About configuring the MSDTC service group . | |
| For configuring an active/active cluster: | |
| See About running SQL Server in an active-active clustered environment . | |
| For configuring a disaster recovery set up: | |
| See Setting up the disaster recovery cluster . | |
| Configure a standalone SQL Server server | You can configure a standalone SQL Server server in the following two cases\: |
| - You have a standalone SQL Server server and want to add it to the VCS cluster | |
| - You have already installed the application on the systems where you want to configure the application for high availability | |
| See Configuring a standalone SQL Server for high availablility . |