sys.sp_rda_get_rpo_duration (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later versions
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 information, see Stretch Database reduces the risk of data loss for your Azure data by retaining migrated rows temporarily.
Important
Stretch Database is deprecated in SQL Server 2022 (16.x) and Azure SQL Database. This feature will be removed in a future version of the Database Engine. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Transact-SQL syntax conventions
Syntax
sp_rda_get_rpo_duration @durationinhours OUTPUT
[ ; ]
Arguments
@durationinhours OUTPUT
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).
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for