設定遠端資料封存伺服器組態選項Configure the remote data archive Server Configuration Option

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

使用 [遠端資料封存] 選項,指定是否在伺服器上啟用資料庫和資料表進行「延伸」。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.

[遠端資料封存] 選項可以有下列值。The remote data archive option can have the following values.

ReplTest1Value DescriptionDescription
00 無法在伺服器上啟用資料庫和資料表進行「延伸」。Databases and tables on the server cannot be enabled for Stretch.
11 可以在伺服器上啟用資料庫和資料表進行「延伸」。Databases and tables on the server can be enabled for Stretch.

執行 sp_configure 以設定 [遠端資料封存] 選項的值需要 sysadmin 或 serveradmin 權限。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. 此範例會將 [遠端資料封存] 選項的值設為 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)