Restore can't access backup file
Posted on 2013-06-27
A third party vendor was given a database backup, did some work on it, and returned the updated backup.
from disk = N'Somelocaldiskpaththatisreallyasanbecausemachineisvm'
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'Somelocaldiskpaththatisreallyasanbecausemachineisvm'. Operating system error 2(error not found).
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
Occasionally the Operating system error 3 appeared.
Research shows that this is a permissions issue, that the sql service account doesn't have rights on the file.
But it DID have rights to the file and the folder. In fact, I copied the file into the backup folder for the originating database and still nothing.
Having figured out that it was a rights issue, I copied the backup file to a test server, checked the rights and the restore filelistonly worked.
Meanwhile, the vendor talked me through restoring the backup using the SSMS gui. (I was using SSMS 2008R2 from a test server.) The gui worked!
So, my question is, why would the gui work and the script NOT work?
PS Further Details
Server SQL 2005 sp3
Windows 2003 sp2
Backup size is around 1.5GB