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
...