This article explains how to troubleshoot your SQL database restore failures.
Microsoft SQL restore is failing with the following error:
Cannot open backup device 'VDI_Instance_DBName_DIFF'. Operating system error 0x80070005(Access is denied.).
RESTORE DATABASE is terminating abnormally.
This is caused by:
The SQL instance is not running as the Local System account.
Resolve this issue by:
Change the account the SQL instance is running under to the same account the BP Agent is running.