| title | Stretch Database Extended Stored Procedures (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom |
|
|
| ms.date | 06/10/2016 | |
| ms.prod | sql-non-specified | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | bda29952-4b8b-4295-ab78-f24dcb0b03c6 | |
| caps.latest.revision | 11 | |
| author | douglaslMS | |
| ms.author | douglasl | |
| manager | jhubbard |
[!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 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.