Page History
...
- Open the SQL Server Management Studio (SSMS) and connect to the listener name.
- Right click on IDERA Dashboard Repository and select Properties.
- Go to options and set the Recovery Model to Full. Click Ok.
- Repeat steps 2 and 3 for SQL Safe Repository.
- Set the Recovery model of the IDERA Dashboard Repository and SQL Safe Repository databases to Full. Click OK.
- Perform a Full Backup of the IDERA Dashboard Repository and SQL Safe Repository databases.
- 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.
- Connect to all the existing secondary replicas, then click Next.
- Select your data synchronization preference , then click Next.
- Ensure the availability group validation tests are successful. ClickClick 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.
- In SQL Server Management Studio (SSMS), connect to the secondary replica(s) and ensure that the databases have been added successfully.
...