Page History

...

1. Open the SQL Server Management Studio (SSMS) and connect to the listener name.
2. Go to Databases, right click on IDERA Dashboard Repository, and select Properties. Go to options and set the Recovery Model to Full. Click OK.
3. Go to Databases, right click on SQL Safe Repository, and select Properties. Go to options and set the Recovery Model to Full. Click OK.
4. Perform a Full backup of the IDERA Dashboard Repository, go to Databases, and right click on IDERA Dashboard Repository. Go to Tasks, and select Backup. The Backup Database - IDERA Dashboard Repository window appears, select the Backup Type as Full, and click OK.
5. Perform a Full backup of the SQL Safe Repository, go to Databases, and right click on SQL Safe Repository. Go to Tasks, and select 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. 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.
8. 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.
9. Select the IDERA Dashboard Repository and SQL Safe Repository databases for the availability group. Click Next.
10. Select your data synchronization preference  preference, then click Next.
11. Connect to all the existing secondary replicas, then click Next.
12. Ensure the availability group validation tests are successful. Click Next.
13. Once the Database is 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.
14. When the Database is Databases are included to the availability group, the results section displays it. Click Close to exit the wizard.
15. In SQL Server Management Studio (SSMS), connect to the secondary replica(s) and ensure that the databases have been added successfully.

...