April 11, 2019 at 10:28 am
Dear All,
I'm trying to restore a backup, but when I tried to get the backup information from a shared directory and I get the following error message; would you please let me know how how it could be fixed without having to move the backup location?
Msg 3201, Level 16, State 2, Line 2
Cannot open backup device 'directory of the backup file'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 2
RESTORE FILELIST is terminating abnormally.
Thank you in advance!
April 11, 2019 at 10:42 am
The service account for SQL Server needs to have permission on the folder and file. If SQL Server is running under a local account like NT Service\MSSQLSERVER, the account for the machine needs to be granted permissions. The form for a machine account is DOMAIN\MACHINE$.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply