Aracılığıyla paylaş


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