Setting the SQL server resource dependency on the RVG resource
Prev Configuring disaster recovery Next

Setting the SQL server resource dependency on the RVG resource

The SQL Server resource was earlier set to depend on a Volume Manager Disk Group resource that corresponded to the disk group created for the application. After you add the RVG resource for that disk group, you must change the dependency. You set the database resource to depend on the RVG resource instead.

You must set the dependency on the RVG resource on both primary and secondary sites.

The following figure indicates the dependencies required.

Figure: Dependency graph for SQL Server

Dependency graph for SQL Server

To change the SQL Server resource dependency properties

  1. Ensure that the SQL Server resource is offline.
  2. Right-click the SQL Server resource and select Properties.
  3. On the Properties dialog box, select the Dependencies tab.

  4. Make the appropriate selections on the Dependencies tab to:

    • Add the Replicated Volume Group resource to the dependencies.

    • Delete the Volume Manager Disk Group resource from the dependencies.

  5. The cluster configuration is now complete. Online the entire SQL_GROUP group on the primary cluster.
Prev Up Next
Creating the RVG resource Home Normal Volume Replicator operations and recovery procedures