---
title: "sys.remote_data_archive_databases (Transact-SQL)"
description: Learn how sys.remote_data_archive_databases contains one row for each remote database that stores data from a Stretch-enabled local database.
author: rwestMSFT
ms.author: randolphwest
ms.reviewer: mikeray
ms.date: 07/25/2022
ms.prod: sql
ms.technology: stored-procedures
ms.topic: "reference"
f1_keywords:
  - "sys.remote_data_archive_databases"
  - "sys.remote_data_archive_databases_TSQL"
  - "remote_data_archive_databases"
  - "remote_data_archive_databases_TSQL"
helpviewer_keywords:
  - "sys.remote_data_archive_databases catalog view"
dev_langs:
  - "TSQL"
---
# Stretch Database Catalog Views - sys.remote_data_archive_databases

[!INCLUDE [sqlserver2016](../../includes/applies-to-version/sqlserver2016.md)]

Contains one row for each remote database that stores data from a Stretch-enabled local database.

> [!IMPORTANT]  
> Stretch Database is deprecated in [!INCLUDE [sssql22-md](../../includes/sssql22-md.md)]. [!INCLUDE [ssNoteDepFutureAvoid-md](../../includes/ssnotedepfutureavoid-md.md)]

|Column name|Data type|Description|  
|-----------------|---------------|-----------------|  
|**remote_database_id**|**int**|The auto-generated local identifier of the remote database.|  
|**remote_database_name**|**sysname**|The name of the remote database.|  
|**data_source_id**|**int**|The data source used to connect to the remote server|

## See also

- [Stretch Database](../../sql-server/stretch-database/stretch-database.md)