Microsoft SQL DB fails to restore

SUMMARY

This article explains how to troubleshoot your SQL database restore failures.

ISSUE

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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us