| title | sys.fn_hadr_distributed_ag_database_replica (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/14/2016 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 0e6202a1-e872-4f53-99d7-c16b6f712efc | ||||
| caps.latest.revision | 9 | ||||
| ms.author | mikeray | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx_md]
Used to map a database in a distributed availability group to the database in the local availability group.
Transact-SQL Syntax Conventions
sys.fn_hadr_distributed_ag_database_replica( lag_Id, database_id )
'lag_Id'
Is the identifier of the distributed availability group. lag_Id is type uniqueidentifier.
'database_id'
Is the identifier of the database in a distributed availability group. database_id is type uniqueidentifier.
Returns the following information.
| Column name | Data type | Description |
|---|---|---|
| group_database_id | uniqueidentifier | ID of the database in the local availability group. |
The following example passes in the database ID in a distributed availability group. It returns a table with the database ID associated with the local availability group.
DECLARE @lagId uniqueidentifier = '4A03D1A8-4AE6-B153-E7E9-ED22A546008D'
DECLARE @databaseId uniqueidentifier = '3FFA882A-C4C3-5B9E-A203-8F44BD9659F7'
SELECT * FROM sys.fn_hadr_distributed_ag_database_replica(@lagId, @databaseId)
GO
Always On Availability Groups Functions (Transact-SQL)
Always On Availability Groups (SQL Server)
Distributed Availability Groups (Always On Availability Groups)
CREATE AVAILABILITY GROUP (Transact-SQL)
ALTER AVAILABILITY GROUP (Transact-SQL)