p To add VirtualManagerDB to the AlwaysOn High Availability Group, perform the following steps: 1. Open SQL Server Management Studio, navigate to AlwaysOn High Availability I SysCtrDBs (Primary), right-click on Availability Databases, and click on Add Database. This is shown in the following screenshot: Object Explorer Connect DEMO-SQL01 (SQL Server 11.0.3000 - DEMO\ADMINU Databases Security Server Objects Replication AlwaysOn High Availability Availability Groups SysCtrDBs (Primary) Availability Replicas Availability Databases TmpVMMDB Add Database Availability Group Start PowerShell Management Integration Services Catalogs Reports SQL Server Agent Refresh DEMO-SOL02 (SOL Server 11.0.30 2. Read the introduction screen and click on Next. 3. Select VirtualManagerDB, ensure the database has "Meets requirements". If not, ensure you have changed the Recovery model option to Full and created a full backup. Click on Next. 4. On the Select Initial Data Synchronization page, the share that was previously used will be shown. Change this share if necessary. Click on Next. You will then be prompted to connect to the second node of the AlwaysOn High Availability Group. Click on Connect. Then, click on Connect again. Click on Next. Ensure the validation checks are all passed; if not, rectify the failures. Click on Next. 7. On the Summary page, click on Finish. The VirtualManagerDB database will then be added to the AlwaysOn High Availability Group. Chapter 1 Removing TmpVMMDB from AlwaysOn High Availability Group Now that the VirtualManagerDB database has been added to the AlwaysOn High Availability Group, the TmpVMMDB database can be removed from the SysCtrDBs AlwaysOn High Availability Group. To do this, perform the following steps: 1. Open SQL Server Management Studio, navigate to AlwaysOn High Availability SysCtrDBs (Primary) I Availability Databases, right-click on TmpVMMDB, and click on Remove Database from Availability Group. This is shown in the following screenshot: Object Explorer Connect DEMO-SQL01 (SQL Server 11.0