Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
mie0812
Starting Member
3 Posts |
Posted - 2008-06-14 : 00:07:48
|
H guys,Good day to you all.I need your help regarding sql backup failed. I'am receiving the following error as stated below. what could be the reason behind this as previously this job is working fine as normal. ---------------------------------------------------------------------"BackupDiskFile::CreateMedia: Backup device '\\ccrptr01\lend_to_decade\MSSQL\BACKUP\ccdeca01\DECADE_HISTORY_tlog_200806131600.TRN' failed to create.Operating system error = 5(Access is denied.)."---------------------------------------------------------------------Appreciated your feedback on this. |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 00:26:49
|
Did you change sql agent service account or that acount's file access permission? |
|
|
mie0812
Starting Member
3 Posts |
Posted - 2008-06-14 : 00:42:40
|
Hi rmiao, thanks for your feedback.No changes on the sql agent account services and also the account file access permission.FYI,the sql agent account is configured to run using localsystem which is a same as previous working state.I've checked the path are ok, no changes on files access permission as well or it might be other possibility... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 00:51:57
|
But your backup location sounds on remote server, localsystem can't access remote location at all. How can you make it work? |
|
|
mie0812
Starting Member
3 Posts |
Posted - 2008-06-14 : 01:20:02
|
Hi rmiao,Thanks, but once again i've checked the log history for this job and please refer below:--------------------------failed history log;Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.---------------------------------FYI..the job has been successfully ran last 2 days..KIndly please refer below:--------------------------------success history log;Executed as user: NT AUTHORITY\SYSTEM. output (null)Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.2039 Copyright (C) Microsoft Corporation, 1995 - 1998. The step succeeded.-----------------------------------------it seems like there's no issue with 'localsystem' as the job was successfully run before. Kindly please advice on this.. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 17:13:36
|
Double check sql server log to find out log backup status and location in last 2 days. By the way, did you change backup location? |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2008-06-18 : 11:27:44
|
Open Query Analyzer and run this xp_cmdshell to list files in the directory (to check if your id has permissions). Please note, you will have to enable xp_cmdshell on SQL 2005 and use the same user id to login to query analyzer as your SQL Agent service account.xp_cmdshell 'dir "\\ccrptr01\lend_to_decade\MSSQL\BACKUP\ccdeca01\*"' |
|
|
|
|
|
|
|