Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from May 29 '13 at 2:18

This question came from our site for professional and enthusiast programmers.

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? – criticalfix May 28 '13 at 18:04

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';
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.