September 8, 2015 at 10:32 pm
Hi All,
I have an issue with DBCC Check DB maintenance plan . I run it in my production last nite.
After running for 1 hour , the package failed ( the step failed )
As below :
Executed as user: ETSPDCSQL1-VW\SYSTEM. ....0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 22:06:13 Progress: 2015-09-08 22:06:14.11 Source: {F0BABEC1-ECBF-4B7D-86BE-7C2C99A08ED8} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2015-09-08 22:06:14.17 Source: Execute T-SQL Statement Task Executing query " USE [master] ".: 1% complete End Progress Progress: 2015-09-08 22:06:26.77 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'master') WITH NO_INFOMSGS ".: 2% complete End Progress Progress: 2015-09-08 22:06:26.78 Source: Execute T-SQL Statement Task Executing query "USE [model] ".: 3% complete End Progress Progress: 2015-09-08 22:06:27.50 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'model') WITH NO_INFOMSGS ".: 4% complete End Progress Progress: 2015-09-08 22:06:27.50 Source: Execute T-SQL Statement Task Executing query "USE [msdb] ".: 5% complete End Progress Progress: 2015-09-08 22:06:30.75 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'msdb') WITH NO_INFOMSGS ".: 6% complete End Progress Progress: 2015-09-08 22:06:30.75 Source: Execute T-SQL Statement Task Executing query "USE [Data_CDCHillsBicycle] ".: 8% complete End Progress Progress: 2015-09-08 22:08:05.69 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'Data_CDCHillsBicycle') WITH NO_INFOMS...".: 9% complete End Progress Progress: 2015-09-08 22:08:05.69 Source: Execute T-SQL Statement Task Executing query "USE [ASSET_SOURCE] ".: 10% complete End Progress Progress: 2015-09-08 22:11:01.75 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'ASSET_SOURCE') WITH NO_INFOMSGS ".: 11% complete End Progress Progress: 2015-09-08 22:11:01.75 Source: Execute T-SQL Statement Task Executing query "USE [Data_Bicycleabout] ".: 12% complete End Progress Progress: 2015-09-08 22:11:52.37 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'Data_Bicycleabout') WITH NO_INFOMSGS ...".: 13% complete End Progress Progress: 2015-09-08 22:11:52.38 Source: Execute T-SQL Statement Task Executing query "USE [Data_Bicycleways] ".: 15% complete End Progress Progress: 2015-09-08 22:16:05.87 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'Data_Bicycleways') WITH NO_INFOMSGS ".: 16% complete End Progress Progress: 2015-09-08 22:16:05.87 Source: Execute T-SQL Statement Task Executing query "USE [Data_CDCWestBicycle] ".: 17% complete End Progress Progress: 2015-09-08 22:16:31.87 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'Data_CDCWestBicycle') WITH NO_INFOMSG...".: 18% complete End Progress Progress: 2015-09-08 22:16:31.87 Source: Execute T-SQL Statement Task Executing query "USE [Data_CDCHunterValley] ".: 19% complete End Progress Progress: 2015-09-08 22:17:46.67 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'Data_CDCHunterValley') WITH NO_IN...".: 20% complete End Progress Progress: 2015-09-08 22:17:46.67 Source: Execute T-SQL Statement Task Executing query "USE [Data_DionsBicycleService] ".: 22% complete End Progress Progress: 2015-09-08 22:17:58.54 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'Data_DionsBicycleService') WITH NO_IN...".: 23% complete End Progress Progress: 2015-09-08 22:17:58.54 Source: Execute T-SQL Statement Task Executing query "USE [Data_Oliver] ".: 24% complete End Progress Progress: 2015-09-08 22:18:12.02 Source: Execute T-SQL Statement Task Executing query "DBCC CHECKDB(N'Data_Oliver') WITH NO_I...".: 25% complete End Progress Progress: 201... The package execution fa... The step failed.
What I should do to troubleshoot this issue?
Much appreciate on your feedback
Many thanks
September 8, 2015 at 10:47 pm
Run DBCC CheckDB ('[db_name]') WITH NO_INFOMSGS, ALL_ERRORMSGS and post the full unedited output.
😎
BTW, how much free disk space does the server have?
September 8, 2015 at 11:51 pm
OK I will run it tomorrow nite and keep you posted
Many thanks for your feed back
September 10, 2015 at 12:51 am
Hi..
I run DBCC Checkdb again using your recommended script but the error is still the same . I tried to run manually ( in query window ) then I got message : Command run successfully
Very curious why it behaves like that .
Server still has hundreds of GB so it shouldn’t be the cause .
Can you please advise?
Thank you
September 10, 2015 at 2:51 am
Set the job to output to a file, so that we can see the full messages. There's no error in the fragment you posted.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2015 at 4:07 am
Do configure the log to write to a text file to get the full error message. meanwhile, you may also check the SQL Server error log to see if the checkdb did complete for the particular database.
Regards,
Raj
September 13, 2015 at 7:35 pm
Hi Gail,
Thanks for the response . The error from output file is : The package execution returned DTSER_FAILURE (1)
Cheers
September 14, 2015 at 1:25 am
Did you include step level output?
Anyways, can you check if checkdb completed for all databases at the scheduled time via SQL Error log?
Regards,
Raj
September 14, 2015 at 2:49 am
WhiteLotus (9/13/2015)
Thanks for the response . The error from output file is : The package execution returned DTSER_FAILURE (1)
What logging did you enable to get that?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 16, 2015 at 12:03 am
HI All ,
I came across an article about this ? Link http://sqlblog.com/blogs/eric_johnson/archive/2009/12/23/troubleshooting-a-failed-maintenance-plan.aspx
EXEC sys.sp_configure N'user options', 0 RECONFIGURE
What do you if I execute that statement?
PS : I enable output file to textfile
Cheers
September 21, 2015 at 11:44 pm
Any comment about this ?
EXEC sys.sp_configure N'user options', 0 RECONFIGURE
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply