I am running SQL server 2008 and trying to restore from a backup file.

Note: the backup file and folder and read/write access to "everyone". Running the command as "master"



Gives the following error:

Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'D:\path'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.

Thanks, Bruce

  • You mean D:\path\filename.bak, don't you? I found this syntax in an old post here and more documentation here. Alternatively, have you tried restoring through the GUI to see whether you can get access that way? May 28, 2013 at 18:04

2 Answers 2


You need to actually specify the backup file in the path. It's not the file list in an NTFS directory, as it seems may be your understanding. It's the file list of the database files in the backup file.

What you should be doing is:

restore filelistonly
from disk = 'D:\path\backupfile.bak';

Had this error when restoring from a mapped drive (Actually a drive that was mapped by VirtualBox)

Fixed by moving data to a 'real' local disk

  • In this case though, he just used the incorrect syntax, the original answer is more correct Nov 12, 2019 at 8:32
  • Yes it is, but this is what people find when googling for answers
    – fiat
    Nov 12, 2019 at 9:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.