September 5, 2013 at 7:57 am
Hi All
here we are trying to take a backup using job but we are getting error message we are trying to get the details from view history, and even viewer and we tried to take the backup manually also we are getting below error.
Cannot open backup device 'D:\Backup\ION_DB_UAT_03\ION_DB_UAT_03_backup_05_Sep_2013_06_46_09.bak'. Operating system error 5(Access is denied.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
please advise me on this.
September 5, 2013 at 8:04 am
New persopn (9/5/2013)
Cannot open backup device 'D:\Backup\ION_DB_UAT_03\ION_DB_UAT_03_backup_05_Sep_2013_06_46_09.bak'. Operating system error 5(Access is denied.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013).
Is D:\Backup\ION_DB_UAT_03\ a valid path?
Do you have appropriate security settings to write a file there?
September 5, 2013 at 8:22 am
which type of permission is required. here sql agent job is running under local service account.
September 5, 2013 at 8:26 am
The local service account must be able to access and write to that location.
September 5, 2013 at 8:33 am
even i added the local service account to that folder still same problem
September 5, 2013 at 9:10 am
Control panel->administrative tools->services-> SQL Server
Properties
Log on as local system account
AND
Allow service to interact with desktop
September 6, 2013 at 3:09 am
here my sql services are running under network service account. agent service is running on local account. in sam instance all other jobs are working fine except this job.
September 6, 2013 at 3:12 am
in view history we found the error as "Executed as user: NT AUTHORITY\SYSTEM. Cannot open backup device 'D:\Backup\ION_DB_UAT_03\ION_DB_UAT_03_backup_06_Sep_2013_02_08_10.bak'. Operating system error 5(Access is denied.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
September 6, 2013 at 3:28 am
Is this really a local drive or maybe a mapped network share?
[font="Verdana"]Markus Bohse[/font]
September 6, 2013 at 3:36 am
local drive only. we dont have the san setup
September 6, 2013 at 4:37 am
one thing here we can able to take the backup manually. but the job is not working. earlier it is fine only from yesterday on words we are getting this error.
September 6, 2013 at 9:35 am
Do you know what was changed yesterday?
Is it possible that the Sql Agent account was changed from local to network?
The account used to start the Agent service needs access to the backup file.
September 9, 2013 at 2:11 am
1.Can you try to change the location of the backup to some other Drive and check if you r facing the same issue ?
2.Also, what is the result if you try to manually take a backup on the same location ?
3.To rule out the possibility of permissions issue, is it possible to try to go to the folder -> Right click -> Properties ->Security -> Add 'Everyone' and give Full COntrol to everyone and then quickly try running the backup job again(Please check with your sys admins if this is permissible to narrow down the issue and then revert back the changes).
If the no 3 succeeds, you might have to grant proper permissions to your Sql and Sql agent accounts on the backup folder.
September 10, 2013 at 5:06 am
Thanks all.
Now the isue is solved.
here we dont have the proper permission on to that folder. we have granted it. now the job is working fine.
thanks for your help. keep it continue
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply