Stretch Database Extended Stored Procedures (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later
This section describes the extended stored procedures that are related to Stretch Database.
In This Section
sys.sp_rda_deauthorize_db Removes the authenticated connection between a local Stretch-enabled database and the remote Azure database.
sys.sp_rda_get_rpo_duration 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 restore is necessary.
sys.sp_rda_reauthorize_db Restores the authenticated connection between a local database enabled for Stretch and the remote database.
sys.sp_rda_reconcile_batch
Reconciles the batch ID stored in the Stretch-enabled SQL Server table for the most recently migrated data with the batch ID stored in the remote Azure table.
sys.sp_rda_reconcile_columns Reconciles the columns in the remote Azure table to the columns in the Stretch-enabled SQL Server table.
sys.sp_rda_reconcile_indexes Queues a schema task to reconcile indexes on the remote table.
sys.sp_rda_set_query_mode Specifies whether queries against the current Stretch-enabled database and its tables return both local and remote data (the default), or local data only.
sys.sp_rda_set_rpo_duration 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 restore is necessary.
sys.sp_rda_test_connection Tests the connection from SQL Server to the remote Azure server and reports problems that may prevent data migration.