| title | Server Configuration: remote data archive |
|---|---|
| description | Learn how to use the remote data archive option in SQL Server to specify whether databases and tables on the server can be enabled for Stretch. |
| author | rwestMSFT |
| ms.author | randolphwest |
| ms.date | 08/26/2025 |
| ms.service | sql |
| ms.subservice | configuration |
| ms.topic | how-to |
[!INCLUDE 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
[!INCLUDE stretch-database-deprecation]
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. |
Running sp_configure to set the value of the remote data archive option requires sysadmin or serveradmin permissions.
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;
GOTo disable the option, set the value to 0.