When you create a new DB or for example when you install application that will create a new DB then you need to add it to the Availability Databases.

Add new database to Availability Databases

  • Change the Recovery Model of the new DB to Full.
  • Do a Full backup of the database.
      • \\contmng0\Replicas\contdb1c0\AG\agscvmm0\VirtualManagerDB.bak
  • Add Database Wizard
  • Select your data synchronization preference.
  • Connect existing replicas.
  • Check the validation results.
  • Check the results.
  • The new database is synchronized now.

Verify the installation

  • Using Failover Cluster Manager move the role to another node. Application (in my case System Center Virtual Machine Manager) that is using the database should not be affected.
« Previous Next »

Part of the series

  1. Building Microsoft SQL Server AlwaysOn Availability Groups - Part 1 - Design
  2. Building Microsoft SQL Server AlwaysOn Availability Groups - Part 2 - Create cluster and configure OS
  3. Building Microsoft SQL Server AlwaysOn Availability Groups - Part 3 - Installation
  4. Building Microsoft SQL Server AlwaysOn Availability Groups - Part 4 - Enable Availability Groups and create Listener