sys-sp-rda-set-rpo-duration-transact-sql.md

title	sys.sp_rda_set_rpo_duration (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.reviewer
ms.technology	stored-procedures
ms.topic	language-reference
f1_keywords	sys.sp_rda_set_rpo_duration sys.sp_rda_set_rpo_duration_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.sp_rda_set_rpo_duration stored procedure
ms.assetid	95c80c5b-9252-4612-9ea7-544c48834fd2
author	MikeRayMSFT
ms.author	mikeray

sys.sp_rda_set_rpo_duration (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md]

Sets the number of hours of migrated data that SQL Server retains in a staging table to help ensure a full restore of the remote Azure database, if a point in time restore is necessary.

For more info, see Stretch Database reduces the risk of data loss for your Azure data by retaining migrated rows temporarily.

Transact-SQL Syntax Conventions

Syntax

    
sp_rda_set_rpo_duration [ @duration_hrs = ] duration_hrs    
    

Arguments

[ @duration_hrs = ] duration_hrs
Is the number of hours (a non-null integer value) of migrated data that you want SQL Server to retain for the current Stretch-enabled database. The default value and the minimum value is 8 hours.

Note

Higher values require more storage space on SQL Server.

Permissions

Requires db_owner permissions.

Remarks

Get the current value by running sys.sp_rda_get_rpo_duration (Transact-SQL).

See Also

sys.sp_rda_get_rpo_duration (Transact-SQL)
Restore Stretch-enabled databases (Stretch Database)
Stretch Database