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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Backup job failed ...

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?
Go to Top of Page

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...
Go to Top of Page

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?
Go to Top of Page

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..
Go to Top of Page

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?
Go to Top of Page

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\*"'
Go to Top of Page
   

- Advertisement -