Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Install the IDERA Dashboard on any server of your machine following the Installation steps.
  2. Go to SQL Server Management Studio and connect to the SQL Server Instance where you installed the IDERA Dashboard.
  3. Under Databases, right click on the IderaDashboardRepository and click properties, on the wizard select run a Full Recovery model.

  4. Right click on IderaDashboardRepository select Tasks and run a Full Back up.

  5. Under Databases
  6. To configure your Availability group, right click on
  7. the IderaDashboardRepository and click properties.
    Image Removed
    Go to the options tab from the left hand side and set the recovery model to full, click Ok to save the changes.
  8. After the backup is complete go to Always on High Availability, and under Availability Group select Add Database
    Image Removed
  9. Click Next on the wizard.
    Image Removed
  10. Select the IDERA Dashboard Repository and Click Next.
    Image Removed
  11. Select Full data synchronization preference and click Next.
    Image Removed
  12. Connect to all the secondary nodes and click Next.
    Image Removed
  13. Let the validation run and click Next.
    Image Removed
  14. Click Finish 
    Image Removed
  15. When the wizard completes click close
    Image Removed
  16. sdfkvnpoefv
    Image Removed
  17. asdfvgas
    Image Removed
  18. afvasv
    Image Removed
  19. Availability groups and select New Availability Group Wizard...
    Image Added
  20. On the Introduction wizard click Next.
    Image Added
  21. Provide a name to the availability group and click Next
    Image Added
  22. On the Select Databases page, a list of available user databases displays, check the box of the IderaDashboardRepository database.
    Image Added
  23. 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.
  24. On the Endpoints tab, make sure that the port number value is 5022.
  25. On the Listener tab, provide a Listener DNS Name with the port number 1433 and an IP number, and click Add....
  26. 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.
    Image Added
  27. On the Select Database Synchronization wizard, select the Full option, and provide a shared folder location accessible by all replicas.
    Image Added
  28. On the Validation wizard, verify that all results return Success and click Next.
    Image Added
  29. The Summary page, displays all the actions to be performed, click Finish.
    Image Added
  30. Verify that all results return Success. Click Close.
    Image Added
  31. aFCWF
  32. On the SQL Server Management Studio, you can verify that the IderaDashboardRepository database is Synchronized on the configured Replicas.

  33. Image Modified



Scroll pdf ignore
Excerpt
IDERA Dashboard provides an integrated user experience for the IDERA products in your environment.