Storage Foundation and High Availability Solutions 7.4.2 HA and DR Solutions Guide for Microsoft SQL Server - Windows
- Section I. Getting started with Storage Foundation and High Availability Solutions for SQL Server
- Introducing SFW HA and the VCS agents for SQL Server
- How is application availability achieved in a VMware virtual environment
- How VCS monitors storage components
- Deployment scenarios for SQL Server
- Reviewing the active-passive HA configuration
- Reviewing a standalone SQL Server configuration
- Reviewing the campus cluster configuration
- Reviewing the Replicated Data Cluster configuration
- About setting up a Replicated Data Cluster configuration
- Disaster recovery configuration
- Reviewing the disaster recovery configuration
- Notes and recommendations for cluster and application configuration
- Configuring disk groups and volumes for SQL Server
- About managing disk groups and volumes
- Configuring the cluster using the Cluster Configuration Wizard
- Installing SQL Server
- Completing configuration steps in SQL Server
- Introducing SFW HA and the VCS agents for SQL Server
- Section II. Configuring SQL Server in a physical environment
- Configuring SQL Server for failover
- About configuring the SQL Server service group
- Configuring the service group in a non-shared storage environment
- Configuring an MSDTC Server service group
- Configuring campus clusters for SQL Server
- Configuring Replicated Data Clusters for SQL Server
- Setting up the Replicated Data Sets (RDS)
- Configuring a RVG service group for replication
- Configuring the resources in the RVG service group for RDC replication
- Configuring the VMDg or VMNSDg resources for the disk groups
- Configuring the RVG Primary resources
- Adding the nodes from the secondary zone to the RDC
- Verifying the RDC configuration
- Configuring disaster recovery for SQL Server
- Setting up your replication environment
- About configuring disaster recovery with the DR wizard
- Configuring replication and global clustering
- Configuring the global cluster option for wide-area failover
- Testing fault readiness by running a fire drill
- About the Fire Drill Wizard
- Prerequisites for a fire drill
- Preparing the fire drill configuration
- Deleting the fire drill configuration
- Configuring SQL Server for failover
- Section III. Configuring SQL Server in a VMware environment
- Configuring application monitoring using the Veritas High Availability solution
- Administering application monitoring
- Administering application monitoring using the Veritas High Availability tab
- Administering application availability using Veritas High Availability dashboard
- Understanding the dashboard work area
- Accessing the dashboard
- Appendix A. Using Veritas AppProtect for vSphere
Managing a plan
After the maintenance plan is created, you can fail over the applications to the clone virtual machine and fail back the applications from the clone to the virtual machine. When the scheduled maintenance is complete, you can delete the cloned virtual machine or retain it for future use.
To perform failover, failback, revert, or delete clone operations, go to Plans, and select a plan. Based on the enabled operation, perform the following tasks:
To fail over the applications to the cloned virtual machine
- Click the Failover icon.
Just In Time Availability (JIT) performs the sequence of failover tasks, which includes taking the application offline, detaching the disks, cloning the virtual machine, attaching the disks, and so on.
To fail back the applications from the clone to the primary virtual machine
- Click the Failback icon.
Just In Time Availability (JIT) performs the sequence of failback tasks, which includes taking the application offline, detaching the disks, attaching the disks, and so on.
To revert a failover or a failback operation
- Click the Revert icon.
If the failover or a failback operation fails, the revert operation restores the applications on the virtual machine, and deletes the clone if created.
To delete a clone
- Click the Delete Clone icon.
After the failback operation is complete, you can delete the clone. By default, the revert operation deletes the clone.
Note:
Alternatively, right-click Plans table on the Plans wizard to perform failover, failback, revert, delete plan, and delete clone operations.
in theOnce you have set up a plan for unplanned recovery during Configure Plan operation, based on the recovery policies selected for the plan, the application is recovered accordingly.
You can manage unplanned recovery policies settings by performing the following operations on the plan and its associated virtual machines.
On the Plans tab, in the plans table which lists all the existing plans, navigate to the required plan and use the right-click option on the selected plan.
Edit: Use this option to modify the configured plans settings such as adding or removing a virtual machine from the plan, and so on.
The same Configuration Plan wizard using which you had set up or configured a plan is displayed with pre-populated details.
See Setting up a plan.
Disable Unplanned Recovery: Use this option to disable the Unplanned Recovery settings.
Enable Unplanned Recovery: Use this option to enable the Unplanned Recovery settings.
Disable Scheduler: Use this option to disable the scheduler settings.
Enable Scheduler: Use this option to enable the scheduler settings.
Delete Plan: Use this option to delete the created plan.
Properties: Use this option to view the properties for unplanned recovery. It displays details such as the selected unplanned recovery policies and the associated operations for the selected policies. It also provides information about the selected scheduler mode for performing boot disk back up operation for the selected virtual machines.
On the Plans tab, in the plans table which lists all the existing plans and its associated virtual machines, navigate to the required virtual machine. Select the required virtual machine and use the right-click option on the selected virtual machine.
Remove VM From Plan: Use this option to delete the virtual machine from the selected plan.
Create Clone Backup: Use this option to create a boot disk backup copy of the virtual machine.
Unplanned Failback: Use this option to fail back the application from the boot disk backup copy of the virtual machine on target ESX to the original virtual machine on primary ESX.
Note:
This option is available only if you have set unplanned recovery policies as Restart VM on target ESX or Restore VM on target ESX.
Properties: Use this option to view properties such as the last run time for backup operation, last successful backup attempt time and the target ESX details.
See Plan states.