Previous Topic: Create Multiple Scenarios for SharePoint Server Farm (distributed deployments)Next Topic: Create SQL Server HA Scenarios

Perform Scenario Management Tasks › Create a New Scenario › Create SQL Server Replication Scenarios

Create SQL Server Replication Scenarios

Creating scenarios is covered in full detail in the Arcserve RHA Administration Guide. This section provides additional information specific to a Microsoft SQL Server disaster recovery scenario. The Scenario Creation Wizard guides you through the steps required to create a disaster recovery 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 scenario now maintains the Replica server so that it can take over for the Master the moment a failure is detected.

You can also protect MS SQL BLOB data. When the master server has MS SQL server enabled FILESTREAMS, the RHA engine discovers and replicates all BLOB data. The engine discovers and replicates even if the BOLB data is stored in locations other than the database files. The root directory also adjusts automatically according to the BLOB data path.

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

To create a SQL 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, Disaster Recovery 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.

  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. 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.
  10. 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.