When refreshing the MS SQL Server vDB using Point-In_Time may cause the recovery to fail with the following Action error message (this error can be intermittent):
Refresh database "EFT". Error Recovery failed for virtual database "EFT" Error Code exception.db.mssqlvdb.vdb.restore.failed Suggested Action Make sure that the SQL Server instance "YOUR_INSTANCE" on the target host "YOUR_SERVER" is up and that the user "YOUR_USER" has privileges to restore a database on the host.
This error is related to a feature on SQL Server called Change Data Capture (CDC) and the issue can be identified by reviewing the tail of the Action error. at in the affects SQL 2014 was an RTM release.
On your target environment with the issue, please run the following as a sysadmin user (as per https://support.microsoft.com/en-au/kb/2567366):
This will cause SQL Server to skip parts of the CDC upgrade process.
Test the Refresh and when completed the testing you can turn it back off with:
Once we patched it with the latest SQL server 2014 service pack the refresh process worked without having the sql instance running the trace flag
For more details, please read this Microsoft KB: https://support.microsoft.com/en-au/kb/2567366