April 18, 2007 at 2:12 pm
Maintenance plan to backup fails. Here is the error:
Date 4/18/2007 4:09:24 PM
Log Job History (MaintenancePlan.Subplan_1)
Step ID 1
Server 006-DEVSQL2005
Job Name MaintenancePlan.Subplan_1
Step Name Subplan_1
Duration 00:00:09
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: jumbo\svcDBASQLAdmin. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:09:25 PM. The return value was unknown. The process exit code was -1073741819. The step failed.
any ideas why is this failing?
April 19, 2007 at 11:26 am
Try to execute the job yourself.
Regards,Yelena Varsha
April 19, 2007 at 11:52 am
What ID is your SQL Server Agent running under?
It should be the same as your SQL Server.
Eric
April 19, 2007 at 12:01 pm
Shahab,
Can you confirm if you have configured your maintenance plan to write report to a text file in directory?
If yes, then that file will give you precise information on what caused the job to fail.
If no, go to repoting section of your maintenance plan and configure to write report to a text file.
Hope this helps.
April 30, 2007 at 9:36 am
I seem to be having the same problem. I can run the Backup DB task, but that doesn't provide a return code (same message as above, although it does back up the databases ok). On success it should move onto the Maintenance plan clear up task, but doesn't. It just reports success and leaves old .bak files in teh backup directory.
If I change the precedence to be on failure (or completion), it moves on to the next task and removes the .bak files. Logging is enabled but nothing is present after the Details section. Typically the message in the log is:
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.2153
Report was generated on "[ServerName]".
Maintenance Plan: System Full Backup
Duration: 00:00:35
Status: Succeeded.
Details:
This example backed up the databases but didn't remove the old .bak files.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply