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 |
See also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for