Stretch Database Catalog Views - sys.remote_data_archive_databases
Applies to: 
SQL Server 2016 (13.x) and later versions
Contains one row for each remote database that stores data from a Stretch-enabled local database.
Important
Stretch Database is deprecated in SQL Server 2022 (16.x) and Azure SQL Database. This feature will be removed in a future version of the Database Engine. 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 |