sys.sp_rda_set_rpo_duration (Transact-SQL)

  • Article

Applies to: SQL Server 2016 (13.x) and later versions

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.

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_set_rpo_duration [ @duration_hrs = ] duration_hrs
[ ; ]

Arguments

[ @duration_hrs = ] duration_hrs

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, which is also 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).

Related content