SQLTeam.com | Weblogs | Forums

Restore: Cannot open backup device error


#1

Hi,

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?

Thanks!


#2

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


#3

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