Building Microsoft SQL Server AlwaysOn Availability Groups – Part 5 – Make another DB Highly-Available – Add it to Availability Databases

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 […]

Building Microsoft SQL Server AlwaysOn Availability Groups – Part 4 – Enable Availability Groups and create Listener

Enable AlwaysOn Availability Groups on all cluster nodes AlwaysOn Availability Groups needs to be enabled on every instance where you want to use it. Select Properties of the instance in the SQL Server Configuration Manager. Tab: AlwaysOn High Availability [x] Enable AlwaysOn Availability Groups Restart the service of the reconfigured instance. Create share for the […]