Versions Compared

Key

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

...

Table of Contents
maxLevel3
minLevel2
separator |

Installing IDERA SQL Inventory Manager with a local Dashboard

...

Go to SQL Server Management Studio and connect to the cluster environment where you installed the SQL Inventory Manager Repository.

Configuring SQL SERVER Database for High Availability

It is assumed that your SQL Server Instance is already configured for High Availability.

If it is required to configure the SQL Server Instance. Please refer to Microsoft Documentation here

  1. Launch SQL Server Management Studio and connect to the cluster environment’s SQL Server Instance where you installed the SQL Inventory Manager Repository.

  2. Open the properties dialog for the SQLInventoryManager  database and set its recovery model to "full".
  3. Create a Full backup for the SQLInventoryManager  database.
  4. Under 'Always ON High Availability' go to the availability group you want to use and select Add Database
  5. On the Add Database to Availability Group dialog click Next and follow these steps:
    1. Select the SQLInventoryManager  database and click Next.


  1. Go to ‘Always ON High Availability’, and under ‘Availability Group’, Select “Add Database..”


Go to the “Options” tab from the Left hand side and set the Recovery model to “Full”

...