---
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: conceptual
---
# Server configuration: remote data archive

[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]

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](/previous-versions/sql/sql-server/stretch-database/enable-stretch-database-for-a-database).

> [!IMPORTANT]  
> [!INCLUDE [stretch-database-deprecation](../../includes/stretch-database-deprecation.md)]

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`.

```sql
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`.

## Related content

- [Enable Stretch Database for a database](/previous-versions/sql/sql-server/stretch-database/enable-stretch-database-for-a-database)
- [Stretch Database](/previous-versions/sql/sql-server/stretch-database/stretch-database)
- [sp_configure (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-configure-transact-sql.md)