Edit

Stretch Database Extended stored procedures (Transact-SQL)

  • Article

Applies to: SQL Server 2016 (13.x) and later versions

This section describes the extended stored procedures that are related to Stretch Database.

Important

Stretch Database is deprecated in SQL Server 2022 (16.x) and Azure SQL Database. This feature will be removed in a future version of the Database Engine. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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.

Related content