The following steps guide you to configure the IDERA Dashboard Repository and SQL Safe Repository databases highly available using the Windows Failover Cluster Service for Windows Server 2008 and above.

  1. Open the SQL Server Management Studio (SSMS) and connect to the secondary nodes of the availability group.
  2. Delete the copies of the IDERA Dashboard Repository and SQL Safe Repository databases from the secondary nodes.
    Go to Databases, right click on IDERA Dashboard Repository, and select Delete.
    Go to Databases, right click on SQL Safe Repository, and select Delete.
  3. In SQL Server Management Studio (SSMS) connect to the active node of the availability group.
  4. Set the recovery model of the IDERA Dashboard Repository and SQL Safe Repository databases to Full.
    Go to Databases, right click on IDERA Dashboard Repository, and select Properties. Go to options and set the Recovery Model to Full. Click OK.
    Go to Databases, right click on SQL Safe Repository, and select Properties. Go to options and set the Recovery Model to Full. Click OK.
  5. Perform a Full backup of the IDERA Dashboard Repository and SQL Safe Repository.
    Go to Databases, right click on IDERA Dashboard Repository, select Tasks, and Backup. The Backup Database - IDERA Dashboard Repository window appears, select the Backup Type as Full, and click OK.
    Go to Databases, right click on SQL Safe Repository, select Tasks, and Backup. The Backup Database - SQL Safe Repository window appears, select the Backup Type as Full, and click OK.
  6. Sign in to the listener machine, open the SQL Server Management Studio (SSMS), and connect to the listener name.
  7. Add Databases to the Availability Group.
    Go to AlwaysOn High Availability, expand Availability Groups, right click on the availability group, and select Add Database. The Add Database to Availability Group wizard opens displaying information about what is needed to add one or more availability databases to an existing availability group. Click Next.
    Select the IDERA Dashboard Repository and SQL Safe Repository databases for the availability group. Click Next.
    Select your data synchronization preference , then click Next.
    Connect to all the existing secondary replicas, then click Next.
    Ensure the availability group validation tests are successful. Click Next.
    Once the Database is ready to add to the availability group, review the Summary and click Finish. If you want to edit your settings, select Previous and make your changes.
    When the Database is included to the availability group, the results section displays it. Click Close to exit the wizard.
  8. In SQL Server Management Studio (SSMS), connect to the secondary replica(s) and ensure that the databases have been added successfully.

Once you complete it, you have successfully upgraded SQL Safe Backup and IDERA Dashboard with the repository databases hosted in an availability group.

You may begin using SQL safe Backup by launching the SQL Safe Management Console from the Start menu.

In an AlwaysOn Environment, SQL Safe Backup will require a license key for each replica to ensure continued functionality of the product after a failover event.

The license key for SQL Safe Backup is tied to the name of the SQL Server instance hosting the repository database.



 |   |  |  |  |