Page History

The following steps guide you through the steps required to make the IDERA Dashboard Repository and SQL Safe Backup 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 listener name.
2. Set the the recovery model of the  of the IDERA Dashboard Repository and SQL Safe Repository databases to  to Full.
   Perform a Full Backup of the Go to Databases, right click on IDERA Dashboard Repository and SQL Safe Repository databases.
3. Right click  on the availability group and select Add Database.

1. Log on with an administrator account to the computer on which you want to install SQL Safe Backup.
2. Run SQL Safe Backup installer.
3. Before you begin, the SQL Safe Backup wizard displays information about what is needed to complete the installation successfully. Click Next.
4. Select the Full setup type to get started. Click Next.
5. Review the license agreement. To accept this license agreement, select the I accept the Terms and Conditions checkbox. Click Next.
6. Specify the Destination Folder where you want to install the SQL Safe Backup and IDERA Dashboard. Specify different path for each one. Click Next.
7. Specify the SQL Server Instance of the availability group, Database Name, and Authentication you want to use for the SQL Safe Backup Repository.
   By default, the Windows Authentication is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the login name and password for this account, and click save.
   Make sure you enable the Same Instance and Authentication as above checkbox for the IDERA Dashboard Repository. 
   Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click Next.
8. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard services will run under.
9. Specify the account to be used by the SQL Safe Backup Management Service to connect to the SQL Safe Backup Repository Database.
   By default, the Windows account specified on the previous step is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the respective SQL Sever login credentials, and click Next.
10. Once SQL Safe is ready to install, review the settings you selected and click Install. If you want to edit your settings, select Back and make your changes.
11. If not already available on the system, the Microsoft Visual C++ 2015 Update installation is requested. Click Install to install the program.
12. When the SQL Safe installation completes, you can either:
    • Go to the Start Menu, select IDERA - SQL Safe Management Console.
    • Open the IDERA Dashboard through the URL https://localhost:9291 from a web browser.
    • Configure the Firewall.
    • Launch the SQL Safe Management Console.
13. By default, the Launch the SQL Safe Management Console checkbox is enable. To complete the installation, disable it, then click Finish. 

Once you complete the SQL Safe Backup installation, configure the databases for high availability.

...

1. , 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.
2. 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.
3. Sign in to the listener machine, open the SQL Server Management Studio (SSMS), and connect to the listener name.
4. Create an availability group.
   Go to AlwaysOn High Availability, right click on Availability Groups, and select New Availability Group.
   The New Availability Group wizard opens. On the General tab assign the Availability group name and in the Availability Replicas Add the information for the secondary replica. Make sure the Readable Secondary option is set as Yes for both replicas. On the Backup Preferences tab select the location where your backup should occur. Click OK.
5. Right click on the Availability Group you just created 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 Databases are 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 Databases are included to the availability group, the results section displays it. Click Close to exit the wizard.
6. 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 installed SQL Safe Backup 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.

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

...