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"
Running
RESTORE FILELISTONLY FROM DISK = 'D:\path'
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
Best Answer
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: