We are restoring big SQL Server database - almost 10TB. But at 95% task failed with error:
Query Result [Microsoft.SqlServer.Management.Common.ExecutionFailureException:Could not upgrade the metadata for database '***' that is enabled for Change Data Capture. The failure occurred when executing the action 'sp_cdc_create_populate_stored_procs'. The error returned was 208: 'line 1, state 6, Invalid object name 'cdc.sp_insdel_1125019189'.'. Use the action and error to determine the cause of the failure and resubmit the request. RESTORE DATABASE successfully processed 0 pages in 175.387 seconds (0.000 MB/sec). An exception occurred while executing a Transact-SQL statement or batch.].
After resume pending job next error was:
Query Result [Microsoft.SqlServer.Management.Common.ExecutionFailureException:The backup or restore was aborted. RESTORE DATABASE is terminating abnormally. Cannot continue the execution because the session is in the kill state. A severe error occurred on the current command. The results, if any, should be discarded. An exception occurred while executing a Transact-SQL statement or batch.].
And after that, every next resume was failed with error:
There is nothing to restore, database [***] is already up to date.
We had exatcly the same problem few months ago and restoring just from full (no transactional log) backup helped. But now we tried to do the same and no result. DB is in HA cluster which is configured in Commvault. Any ideas?
Best answer by Ron PottsView original