sys-fn-hadr-distributed-ag-database-replica-transact-sql.md

title	sys.fn_hadr_distributed_ag_database_replica (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/14/2016
ms.prod	sql
ms.prod_service	database-engine
ms.component	system-functions
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.fn_hadr_distributed_ag_database_replica sys.fn_hadr_distributed_ag_database_replica_TSQL fn_hadr_distributed_ag_database_replica fn_hadr_distributed_ag_database_replica_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.fn_hadr_distributed_ag_database_replica
ms.assetid	0e6202a1-e872-4f53-99d7-c16b6f712efc
caps.latest.revision	9
author	MikeRayMSFT
ms.author	mikeray
manager	craigg

sys.fn_hadr_distributed_ag_database_replica (Transact-SQL)

[!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

Syntax

  
sys.fn_hadr_distributed_ag_database_replica( lag_Id, database_id )  

Arguments

'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.

Tables Returned

Returns the following information.

Column name	Data type	Description
group_database_id	uniqueidentifier	ID of the database in the local availability group.

Examples

Using sys.fn_hadr_distributed_ag_database_replica

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  

See Also

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)