Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

error agent job : error loading a task Expand / Collapse
Posted Sunday, January 13, 2013 9:39 PM


Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
Anyone have an idea why this maintenance backup failed?

All rights reserved. Started: 3:00:00 AM Error: 2013-01-01 03:00:14.14 Code: 0xC0010018 Source: Back Up Database Task Description: Error loading a task. The contact information for the task is "Back Up Database Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;;1". This happens when loading a task fails. End Error Progress: 2013-01-01 03:00:14.72 Source: {D49EC6E3-5390-46F6-9FB1-91BDAD937D3A} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2013-01-01 03:00:15.16 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\... The package execution fa... The step failed.

Thank you in advance!
Post #1406563
Posted Monday, January 14, 2013 7:06 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 18, 2016 4:15 PM
Points: 949, Visits: 1,884
Just to clarify this is a SQL 2000 forum and it appears that your question is about SQL 2005, so it may not be seen by a lot of people.

In SSMS go to Management > Maintenance Plans, right-click on the maintenance plan that failed and select View History. Post the contents of the error from the maintenance plan history here.

Joie Andrew
"Since 1982"
Post #1406704
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse