Specify an availability group name. Select Databases Availability group name: Specify Replicas SysCtrDBs Select Data Synchronization Chapter 1 8. Select the TmpVMMDB database to be added to the Availability Group. Click on Next. On the Specify Replicas page, click on Add Replica and enter the name of the other SQL node. Click on Connect. 10. Once the server has been added, set the options as shown in the following screenshot: Specify an instance of SQL Server to host a secondary replica. Replicas Endpoints Backup Preferences Listener Availability Replicas: Automatic Initial Synchronous Server Instance Failover (Up to Commit (Up to Readable Secondary DEMO-SQL01 Primary DEMO-SQL02 Secondary 11. Click on the Listener tab and select the option to Create an availability group listener. In this example, it will be called SysCtrDBs - AGL. It will listen on port 1433 and have a static IP address. Once configured, click on Next. Replicas Endpoints Backup Preferences Listener Specify your preference for an availability group listener that will provide a client connection point: Do not create an availability group listener now You can create the listener later using the Add Availability Group Listener dialog. Create an availability group listener Specify your listener preferences for this availability group. Listener DNS Name: SysCtrDBs-AGL Port: Network Mode: Static IP Subnet IP Address 172.28.0.0/16 172.28.0.34 Installing Virtual Machine Manager 12. On the Select Initial Data Synchronization page, enter a file share that the account the SQL Server Agent service is running under has Full control over. Click on Next. Select your data synchronization preference. Starts data synchronization by performing full database and log backups for each selected database. These databases are restored to each secondary and joined to the availability group. Specify a shared network location accessible by all replicas: I\DEMO-SQLSEED\SQLShares$ Browse... 13. The next screen will validate the settings you have entered to ensure the Availabi