January 13, 2013 at 9:39 pm
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;http://www.microsoft.com/sql/support/default.asp;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!
January 14, 2013 at 7:06 am
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"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply