Skip to content

stretch-database-catalog-views-sys-remote-data-archive-databases.md

Latest commit

 

History

History
38 lines (32 loc) · 1.52 KB

stretch-database-catalog-views-sys-remote-data-archive-databases.md

File metadata and controls

38 lines (32 loc) · 1.52 KB
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]

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]. [!INCLUDE ssNoteDepFutureAvoid-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