Ask the Community
Groups
Microsoft SQL DB fails to restore - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>This article explains how to troubleshoot your SQL database restore failures.</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <h4 data-id="microsoft-sql-restore-is-failing-with-the-following-error">Microsoft SQL restore is failing with the following error:</h4> <p>Cannot open backup device 'VDI_Instance_DBName_DIFF'. Operating system error 0x80070005(Access is denied.).</p> <p>RESTORE DATABASE is terminating abnormally.</p> <h4 data-id="this-is-caused-by">This is caused by:</h4> <p>The SQL instance is not running as the Local System account.</p> <h4 data-id="resolve-this-issue-by">Resolve this issue by:</h4> <p>Change the account the SQL instance is running under to the same account the BP Agent is running.</p> </article> </main>