December 11, 2012 at 2:28 am
Hi all,
a maintence plan failed last night and im trying to find out why. now apart from the fact that maintenance plans are horrible and this one is rather horrid... is there really no way to find out what went wrong...
The plan is:
DBCC CHECKDB All Databases
FULL BACKUP All Databases
CLEAN UP Delete old files .bak
CLEAN UP delete old files .trn
Job history :
Date10/12/2012 19:30:04
LogJob History (Daily Backup.Subplan_1)
Step ID1
Server
Job NameDaily Backup.Subplan_1
Step NameSubplan_1
Duration00:13:43
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: . ...9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 19:30:38 Progress: 2012-12-10 19:30:44.90 Source: {00CD2D5A-118F-4D19-96AB-FE9631F02CD5}
Executing query "DECLARE @GUID UNIQUEIDENTIFIER
EXECUTE msdb..sp".: 100% complete
End Progress
Progress: 2012-12-10 19:30:49.37 Source: Check Database Integrity Task
Executing query "USE [master] ".: 50% complete
End Progress
Progress: 2012-12-10 19:31:38.83 Source: Check Database Integrity Task
Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete
End Progress
Progress: 2012-12-10 19:31:38.94 Source: Check Database Integrity Task
Executing query "USE [model] ".: 50% complete
End Progress
Progress: 2012-12-10 19:32:00.05 Source: Check Database Integrity Task
Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete
End Progress
Error: 2012-12-10 19:32:... The package execution fa... The step failed.
Looking at the SQL Server Logs: (Note it shows running DBCC CHCEKDB on ALL the databases. so should have started on the backups)
37952012-12-10 19:43:43.350spid56DBCC CHECKDB (db4) WITH no_infomsgs executed by found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 1 seconds.
37942012-12-10 19:43:41.190spid56DBCC CHECKDB (db3) WITH no_infomsgs executed by found 0 errors and repaired 0 errors. Elapsed time: 0 hours 2 minutes 34 seconds.
37932012-12-10 19:41:06.680spid56DBCC CHECKDB (db2) WITH no_infomsgs executed by found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 23 seconds.
37922012-12-10 19:40:42.290spid60DBCC CHECKDB (db1) WITH no_infomsgs executed by found 0 errors and repaired 0 errors. Elapsed time: 0 hours 8 minutes 20 seconds.
37912012-12-10 19:31:58.200spid60DBCC CHECKDB (model) WITH no_infomsgs executed by found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 19 seconds.
37902012-12-10 19:31:38.830spid60DBCC CHECKDB (mssqlsystemresource) WITH no_infomsgs executed by found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 4 seconds.
37892012-12-10 19:31:28.210spid60DBCC CHECKDB (master) WITH no_infomsgs executed by found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 38 seconds.
37882012-12-10 19:30:45.430spid58Configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE statement to install.
I tried looking though the default trace but couldnt see anything there.
Any ideas where else to look?
December 12, 2012 at 4:31 am
see if you can find something in this table sysdbmaintplan_hist
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2012 at 10:55 am
Try the log files, there is a text file for each maintenance plan written. The file path may vary, mine is at C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log
Tim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply