Page History
...
- Open SQL Server Management Studio (SSMS) on the primary node and connect the listener name.
- Set the Recovery Model of the IderaDashboardRepository and SQLdmRepository databases to Full.
- Perform a full backup of the IderaDashboardRepository and SQLdmRepository databases.
- Right-click the appropriate availability group and select Add Database...
- On the Introduction screen of the Add Database to Availability Group wizard, click Next.
- On the Select Database tab, select the IderaDashboardRepository and SQLdmRepository databases, and click Next.
- On the Connect to Replicas tab, connect to the other replica(s) in the availability groups by clicking Connect... next to the Server Instances, and click Next.
- On the Select Data Synchronization tab, select one of the following options for your environment, and click Next.
- Automatic Seeding
- Full database and log backup
- Join only
- Skip initial data synchronization
- On the Validation screen, ensure that all tests are successful and click Next.
- On the Summary screen, verify the actions you selected in the previous steps, and click Finish.
- The Results screen displays the summary of the performed actions and their results, click Close to exit the wizard.
- In SSMS connect to the secondary replica(s) and ensure that the databases were added successfully.
- On the server where SQL Diagnostic Manager is installed, restart the services listed below:
- IDERA Dashboard Core Service
- IDERA Dashboard Web Service
- SQLdm Collection Service
- SQLdm Management Service
- SQLdm Predictive Analytics Service
- SQLdm Rest Service
Validate SQL Diagnostic Manager
...
Configuration
- To validate the SQL Diagnostic Manager configuration, launch the Desktop Client.
- Go to
If you see the listener and port as shown in the image above, you have successfully configured the repository databases in an availability group. > Manage License. In the New Key section, you should see the name of the listener and the port instead of the primary node name.
Info |
---|
Consider that the Select Cluster Name option is a field only for a Scale-out configuration. |
...