Stretch Database Catalog Views - sys.remote_data_archive_databases

Applies to: SQL Server 2016 (13.x) and later

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


Stretch Database is deprecated in SQL Server 2022 (16.x). This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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