How to Add Contained Databases in SQL Server 2016 Availability Group - SQL Server 2016 DBA Tutorial

Scenario:

You are working as SQL Server DBA and you are asked to add a Contained Database in AlwaysOn Availability Group. What steps you will follow?

Solution:

In this video demo, you will go through all the steps you need to add a Contained Database to AlwaysOn Availability Group.


Items covered

  • How to create Contained Databases in SQL Server 2016?
  • How to add Contained Database into Availability Group?
  • How to Connect to Contained Database using Availability Listener?
  • How to Failover Contained Database Availability Group?