Skip to main content
Version: v23.0

Re-creating a Contained Availability Group

Summary​

When re-creating a contained availability group, additional optional parameters are needed in order for SQL Server to reuse the existing system databases.

Information​

The optional parameter of REUSE_SYSTEM_DATABASES will need to be supplied.

For more information about this optional parameter, please see the following Microsoft document.

Additional Information​

  • With DxAdmin, after right-clicking on the Vhost and selecting "Add availability group" there will be an input box to supply optional parameters. Input CONTAINED REUSE_SYSTEM_DATABASES.

  • With the dxcli add-ags command, supply the [ag_options] parameter with "CONTAINED REUSE_SYSTEM_DATABASES"

  • With the DxPS Dx-AddAGS command, supply the -AGSOptions parameter with "CONTAINED REUSE_SYSTEM_DATABASES".