Stretch Database Extended Stored Procedures (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2016) noAzure SQL Database noAzure 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 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