Stretch Database Extended Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

See Also

Stretch Database