Hi,
I ran a backup procedure and BAK file created.
I moved the file to another server, tried to restore and failed with following error:
"Cannot open backup device 'C:\*****.bak'. Operating system error 5(Access is denied.)"
I checked the file on the original server and the file is accessible: I can see its content with RESTORE FILELISTONLY command.
Any clues?
Thanks,
Mark
Are you using the Restore dialog to do this operation or are you using T-SQL?
Either case, ensure that the account under which SQL server service is running has access to the 'C' drive.
[Venkat]
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment