SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Backup job failed ...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mie0812
Starting Member

Malaysia
3 Posts

Posted - 06/14/2008 :  00:07:48  Show Profile  Click to see mie0812's MSN Messenger address  Send mie0812 a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/14/2008 :  00:26:49  Show Profile  Reply with Quote
Did you change sql agent service account or that acount's file access permission?
Go to Top of Page

mie0812
Starting Member

Malaysia
3 Posts

Posted - 06/14/2008 :  00:42:40  Show Profile  Click to see mie0812's MSN Messenger address  Send mie0812 a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/14/2008 :  00:51:57  Show Profile  Reply with Quote
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

Malaysia
3 Posts

Posted - 06/14/2008 :  01:20:02  Show Profile  Click to see mie0812's MSN Messenger address  Send mie0812 a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/14/2008 :  17:13:36  Show Profile  Reply with Quote
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 - 06/18/2008 :  11:27:44  Show Profile  Reply with Quote
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\*"'

Edited by - sqldba20 on 06/18/2008 11:30:39
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000