The following steps guide you to make the SQL Safe Backup Repository databases highly available using the Windows Failover Cluster Service for Windows Server 2008 and above.
- Open the SQL Server Management Studio (SSMS) and connect to the listener name.
- Set the recovery model of the SQL Safe Repository databases to Full.
- Go to Databases, right-click on SQL Safe Repository, and select Properties.
- Go to Options and set the Recovery Model to Full. Click OK.
- Perform a Full backup of the SQL Safe Repository.
- Go to Databases, right-click on SQL Safe Repository, select Tasks, and Backup.
- The Backup Database - SQL Safe Repository window opens.
- Select Backup Type as Full. Click OK.
- Sign in to the Listener Machine.
- Open the SQL Server Management Studio (SSMS), and connect to the listener name.
- 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.
- In the Availability Replicas, add the information for the secondary replica. Ensure 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.
- 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 SQL Safe Repository databases for the availability group. Click Next.
- Select your data synchronization preference. Click Next.
- Connect to all the existing secondary replicas. 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. Click Finish.
If you want to edit your settings, select Previous to apply your changes. - When the Databases are included in the availability group, the results section displays them. Click Close to exit the wizard.
- 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.
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 listener name should be used when generating a license key for the repository database.
In terms of licensing the agent, it still needs to be licensed for each replica.