SQLTeam.com | Weblogs | Forums

Restore: Cannot open backup device error



I have worked with this issue before, but still got stuck here. I understand the why part, but nevertheless had hard time to make it work.

I installed a new SQL server 2012 to a default instance to a new windows server 2012 R2.
Then copied a production full backup into C:\backup
But running restore command within SSMS got
Cannot open backup device 'C:\backup\db_backup_2016_02_17_221000_7225667.bak'. Operating system error 5(Access is denied.).
Under SQL configure manager, the sql server service account is running as NT Service\MSSQLSERVICE,
But I have hard time to add it to the C:\backup folder. My personal account is in admin group. I should be able to change the permission, but.
Should I reinstall sql or change it to run under one of the built-in account? and which one is easier to work with under this windows environment?



You do not need to reinstall SQL for this. Changing the service account would fix it, but it's not what is recommended these days. Try this: http://dba.stackexchange.com/questions/47304/bak-file-not-visible-in-any-directory-in-ssms


Give full rights to the backup folder in C drive for the user.
Open the SSMS as administrative mode