Consider the following scenario:
- You delete some batches from the recovery point objective (RPO) table and from remote Azure tables when you use Microsoft SQL Server 2016.
- You execute sys.sp_rda_reconcile_batch on a local Stretch-enabled table to reconcile local and remote batch IDs.
- You restore the remote Azure tables to a restore point.
In this scenario, you can no longer migrate data from the local Stretch-enabled table to the remote Azure tables. Additionally, when you execute a query that queries data from the remote Azure tables, you receive an error message that resembles the following:
Cannot query table '%.*ls' because data reconciliation is in progress. This is part of the automatic recovery process for a remote data archive enabled table. You may check the status of this operation in sys.remote_data_archive_tables.