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.
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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3174076 - Last Review: Jul 26, 2016 - Revision: 1