Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Use the remote data archive option to specify whether databases and tables on the server can be enabled for Stretch. For more info, see Enable Stretch Database for a 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.
The remote data archive option can have the following values.
| Value | Description |
|---|---|
0 |
Databases and tables on the server can't be enabled for Stretch. |
1 |
Databases and tables on the server can be enabled for Stretch. |
Permissions
Running sp_configure to set the value of the remote data archive option requires sysadmin or serveradmin permissions.
Examples
The following example first displays the current setting of the remote data archive option. Then the example enables the remote data archive option by setting its value to 1.
EXECUTE sp_configure 'remote data archive';
GO
EXECUTE sp_configure 'remote data archive', '1';
GO
RECONFIGURE;
GO
To disable the option, set the value to 0.