Page History
...
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
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
Launch SQL Server Management Studio and connect to the cluster environment’s SQL Server Instance where you installed the SQL Inventory Manager Repository.
- Open the properties dialog for the SQLInventoryManager database and set its recovery model to "full".
- Create a Full backup for the SQLInventoryManager database.
- Under 'Always ON High Availability' go to the availability group you want to use and select Add Database
- On the Add Database to Availability Group dialog click Next and follow these steps:
- Select the SQLInventoryManager database and click Next.
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”
...