Availability Groups with Only Primary Replica

• alex.sqldba

  SSChampion

  Points: 10254

  More actions

  November 25, 2017 at 2:28 pm

  #409800

  Evening Guys,

  We have availability groups in production. However on dev we have just single instance and single copies of the DB's. They can be rebuilt from scripts and backups and HA is not necessary in that environment.

  However they are struggling to not perform cross DB queries into databases that would live in different availability groups in production. So to help cement this I wanted to create AG's in dev to prevent them doing so and giving them a hard border around certain databases.

  Is it possible to create availability groups without having any replicas involved?

  Cheers
  Alex

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  November 27, 2017 at 4:31 am

  #1969488

  Yes, you can create single node availability groups. Prior to SQL 2017 you need a Windows cluster still (again, can be a single node cluster).