Page History
...
- Install the IDERA Dashboard on any server of your machine following the Installation steps.
- Go to SQL Server Management Studio and connect to the SQL Server Instance where you installed the IDERA Dashboard.
- Under Databases, right click on the IderaDashboardRepository and click properties, on the wizard select run a Full Recovery model.
- Right click on IderaDashboardRepository select Tasks and run a Full Back up.
- To configure your Availability group, right click on the IderaDashboardRepository and click properties.
- After the backup is complete go to Always on High Availability, and under Availability Group select Add Database
- Click Next on the wizard.
- Select the IDERA Dashboard Repository and Click Next.
- Select Full data synchronization preference and click Next.
- Connect to all the secondary nodes and click Next.
- Let the validation run and click Next.
- Click Finish
- When the wizard completes click close
- sdfkvnpoefv
- asdfvgas
- afvasv
- Availability groups and select New Availability Group Wizard...
- On the Introduction wizard click Next.
- Provide a name to the availability group and click Next.
- On the Select Databases page, a list of available user databases displays, check the box of the IderaDashboardRepository database.
- The Specify Replicas wizard displays as default the server where you are configuring your the availability group, click Add Replica..., and browse the servers to be included on the Availability Group.
Check the options, Automatic Failover (Up to 2) and Synchronous Commit (up to 3) on all your replicas, and select No on Readable Secondary. - On the Endpoints tab, make sure that the port number value is 5022.
- On the Listener tab, provide a Listener DNS Name with the port number 1433 and an IP number, and click Add....
- On the wizard provide an IP address. In the Add IP Address dialog box, enter your preferred virtual IP address in the IPv4 Address field. Click OK. Click Next.
- On the Select Database Synchronization wizard, select the Full option, and provide a shared folder location accessible by all replicas.
- On the Validation wizard, verify that all results return Success and click Next.
- The Summary page, displays all the actions to be performed, click Finish.
- Verify that all results return Success. Click Close.
- On the SQL Server Management Studio, you can verify that the IderaDashboardRepository database is Synchronized on the configured Replicas.
Go to the options tab from the left hand side and set the recovery model to full, click Ok to save the changes.
Scroll pdf ignore | ||
---|---|---|
|