Configure the remote data archive Server Configuration Option

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

The remote data archive option can have the following values.

Value Description
0 Databases and tables on the server cannot 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.

Example

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.

EXEC sp_configure 'remote data archive';  
GO  
EXEC sp_configure 'remote data archive' , '1';  
GO  
RECONFIGURE;  
GO  

To disable the option, set the value to 0.

See Also

Enable Stretch Database for a database
Stretch Database
sp_configure (Transact-SQL)