Table of Contents

Class AvailabilitySchema.AvailabilityDatabasesCluster

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.availability_databases_cluster (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains one row for each availability database on the instance of SQL Server that is hosting an availability replica for any Always On availability group in the Windows Server Failover Clustering (WSFC) cluster, regardless of whether the local copy database has been joined to the availability group yet.

note


When a database is added to an availability group, the primary database is automatically joined to the group. Secondary databases must be prepared on each secondary replica before they can be joined to the availability group.


See sys.availability_databases_cluster.

[Table(Schema = "sys", Name = "availability_databases_cluster", IsView = true)]
public class AvailabilitySchema.AvailabilityDatabasesCluster
Inheritance
AvailabilitySchema.AvailabilityDatabasesCluster
Extension Methods

Properties

DatabaseName

Name of the database that was added to the availability group.

[Column("database_name")]
[Nullable]
public string? DatabaseName { get; set; }

Property Value

string

GroupDatabaseID

Unique identifier of the database within the availability group, if any, in which the database is participating. group_database_id is the same for this database on the primary replica and on every secondary replica on which the database has been joined to the availability group.

NULL = database is not part of an availability replica in any availability group.

[Column("group_database_id")]
[NotNull]
public Guid GroupDatabaseID { get; set; }

Property Value

Guid

GroupID

Unique identifier of the availability group in which the availability group, if any, in which the database is participating.

NULL = database is not part of an availability replica of in availability group.

[Column("group_id")]
[NotNull]
public Guid GroupID { get; set; }

Property Value

Guid