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

title	sys.sp_rda_get_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_get_rpo_duration sys.sp_rda_get_rpo_duration_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.sp_rda_get_rpo_duration stored procedure
ms.assetid	35882067-3072-47ff-9024-ca453c0f49a7
author	MikeRayMSFT
ms.author	mikeray

sys.sp_rda_get_rpo_duration (Transact-SQL)

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

Gets 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_get_rpo_duration @durationinhours output    
    

Output parameter

@durationinhours
Is the number of hours (a non-null integer value) of migrated data that SQL Server retains for the current Stretch-enabled database.

Permissions

Requires db_owner permissions.

Remarks

Change the value by running sys.sp_rda_set_rpo_duration (Transact-SQL).

See Also

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