Previous Topic: Create SQL Server Replication ScenariosNext Topic: Manage Services

Creating Replication and High Availability Scenarios › Create SQL Server HA Scenarios

Create SQL Server HA Scenarios

Creating scenarios is covered in full detail in the Arcserve RHA Administration Guide. This section provides additional information specific to a Microsoft SQL High Availability scenario. The Scenario Creation Wizard guides you through the steps required to create a high availability scenario. When completed, you should run your scenario to start data synchronization. Synchronization could take a while, depending on database size and network bandwidth. Once synchronization completes, your high availability scenario now maintains the Replica server so that it can take over for the Master the moment a failure is detected.

Please read the entire procedure, including cross-referenced information, if applicable, before you proceed.

To create a SQL HA scenario

  1. From the Arcserve RHA Manager, choose Scenario, New or click the New Scenario button.
  2. When the Welcome dialog opens, select Create New Scenario and click Next.
  3. When the Select Scenario Type dialog opens, select SQL, High Availability Scenario, and Replica Integrity Testing for Assured Recovery (optional). For more information on Assured Recovery, see the Arcserve RHA Administration Guide.
  4. When the Master and Replica hosts dialog opens, name your scenario and provide the hostname or IP address for the Master and Replica servers. If either server is a MSCS cluster, enter the cluster resource virtual server name or IP address. Click Next. For more information, see Redirection Methods.
  5. Wait for Engine Verification to complete and click Next. If needed, click Install to upgrade the Engine on one or both servers and then click Next.

    The Database for Replication dialog opens, listing all auto-discovered results for the specified Master. By default, all databases are included.

    Note: You can only de-select user created databases.

  6. Change selections, as desired and click Next.
  7. When the Scenario Properties dialog opens, configure additional properties, if needed. If you use NTFS ACLs with domain accounts for user access control, we recommend that you choose the Replicate NTFS ACL option and click Next. For more information, see Scenario Properties or the Arcserve RHA Administration Guide.

    The Master and Replica Properties dialog opens.

  8. Accept default settings or make the desired changes and click Next.
  9. Wait for the Switchover Properties dialog to retrieve information. Configure the desired redirection properties and click Next. For more information, see Switching Over and Switching Back.
  10. From the Switchover and Reverse Replication Initiation dialog, choose automatic or manual switchover, and automatic or manual reverse replication, as needed.

    Setting both of these options to automatic is not recommended. For more information, see Scenario Properties or the Arcserve RHA Administration Guide.

  11. Click Next to initiate scenario verification. If errors are reported, you should resolve them before continuing. At successful verification, click Next to complete scenario creation.
  12. Choose Run Now or Finish, as desired. Run Now starts synchronization. Finish allows you to run the scenario later. See Run the Scenario from Outside the Wizard.