配置远程数据存档服务器配置选项Configure the remote data archive Server Configuration Option

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

使用 remote data archive 选项,可以指定能否为服务器上的数据库和表启用延伸。Use the remote data archive option to specify whether databases and tables on the server can be enabled for Stretch. 有关详细信息,请参阅 Enable Stretch Database for a databaseFor more info, see Enable Stretch Database for a database.

remote data archive 选项可以具有下列值。The remote data archive option can have the following values.

ReplTest1Value 描述Description
00 不可以为服务器上的数据库和表启用延伸。Databases and tables on the server cannot be enabled for Stretch.
11 可以为服务器上的数据库和表启用延伸。Databases and tables on the server can be enabled for Stretch.

必须具有 sysadmin 或 serveradmin 权限,才能运行 sp_configure 来设置 远程数据存档 选项的值。Running sp_configure to set the value of the remote data archive option requires sysadmin or serveradmin permissions.

示例Example

下面的示例先显示 remote data archive 选项的当前设置。The following example first displays the current setting of the remote data archive option. 然后,此示例通过将 remote data archive 选项的值设置为 1 来启用这个选项。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  

若要禁用该选项,请将此值设置为 0。To disable the option, set the value to 0.

另请参阅See Also

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