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.
The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Learn about the terminology that Microsoft uses to describe software updates.