| title | Extended Stored Procedures (Transact-SQL) | |
|---|---|---|
| titleSuffix | SQL Server Stretch Database | |
| ms.custom | seo-dt-2019 | |
| ms.date | 06/10/2016 | |
| ms.prod | sql | |
| ms.reviewer | ||
| ms.technology | stored-procedures | |
| ms.topic | language-reference | |
| dev_langs |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | bda29952-4b8b-4295-ab78-f24dcb0b03c6 | |
| author | MikeRayMSFT | |
| ms.author | mikeray |
[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md]
This section describes the extended stored procedures that are related to Stretch Database.
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.