backup maintanence plan failed

Hello,

I created a backup maintanence plan which run good before. I am not sure why it didn't work now.

The error message from job history is:

05/18/2007 09:04:40,backupdbs.backupdbs,Error,0,PEPE\SQL2005PROD,backupdbs.backupdbs,(Job outcome),,The job failed. The Job was invoked by User RMWB3\cs002291. The last step to run was step 1 (backupdbs).,00:00:00,0,0, 0
05/18/2007 09:04:40,backupdbs.backupdbs,Error,1,PEPE\SQL2005PROD,backupdbs.backupdbs,backupdbs,,Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed.,00:00:00,0,0,,,,0

How to debug this problem?

Thanks

Hi,

The actual error should have been logged in the SQL Error Log, please investigate the error log around the time the error occurred.

Jag

|||

I have checked sql agent error log and didn't find any error around that time. Do you mean sql agent error log?

Thanks

|||

i hope this box is a SQL Server 2005 build. In that case , the first thing we check is , whether SP2 applied or not. In sp2 many problems are fixed. If it is not applied, download from Microsoft site and install.

ref ; http://support.microsoft.com/kb/933508

Madhu

|||HI,

Please check the errorlog for that particular time(05/18/2007 09:04:40), you will get the backup error over there. Kindly post the error over here.|||

SQLdba2007,

Please check the SQL Server error rather than SQL agent log.

Jag

|||

There is no error in sql server current log, just no backup info there. There are some errors in sql agent error log .

the error message is:

"unable to read local event log:[reasonarameter is incorrect ] at 12:00am ". my backup maintanence plan start at 11:00pm every day.

I also checked the event log viewer on the box. there are no related errors there and the size is 1.51k.

The DB is sql server 2005 without sp2 applied.

Thanks for all your help!

April

|||

there is no point in trouble shooting this without applying SP2. Service Pack 2 is the minimum requirement to function maintenance plan in SQL Server 2005 and there are many bug fixing done in sp2. So download it and install, it will solve the problem

Madhu

|||

Were you able to resolve this problem? As I have the exact same issue there are no messages in either log file and the error msg displayed is generic. We have installed SP2 and the problem still exists.

|||

The problem is gone after SP2 applied.

Thanks