Post reply

dbcc checkdb part failed in maintenance plan

  • April 10, 2007 at 8:17 am

    #116841

    Hi, not sure if this is an issue with sql 2005 service pack 2 (installed last week). Part of my maintenance plan checks database integrity. The sql shows:

    USE [master]

    GO

    DBCC CHECKDB WITH NO_INFOMSGS

    GO

    USE [model]

    GO

    DBCC CHECKDB WITH NO_INFOMSGS

    GO

    USE [msdb]

    GO

    DBCC CHECKDB WITH NO_INFOMSGS

    This part fails everyday. The error says:

    Check Database Integrity

    Check Database integrity on Local server connection

    Databases: All system databases

    Include indexes

    Task start: 2007-04-10T05:00:39.

    Task end: 2007-04-10T05:00:39.

    Failed0) Alter failed for Server 'XYZ'.

    It seems to me like its trying to alter database by changing to to single user mode, like it would do if you have repair_rebuild argument there, but the code does not show. Does anyone have any clue?

    Thanks,

    Kathleen

     

     

     

     

  • April 10, 2007 at 8:30 pm

    #699676

    http://support.microsoft.com/kb/934459

     


    * Noel

  • April 11, 2007 at 7:34 am

    #699767

    Thanks much!

  • January 29, 2009 at 7:17 am

    #934651

    I got a later version than that kb specifies and still have a problem with checkdb and same error.

    Microsoft SQL Server 2005 - 9.00.3282.00 (X64) Aug 5 2008 00:48:00 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

  • January 29, 2009 at 7:49 am

    #934688

    I have:

    Microsoft SQL Server 2005 - 9.00.3233.00 (X64) Mar 6 2008 21:58:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    The error cleared out a while ago, I forget when. Might have been after installing the patch Noel specified.

  • March 29, 2009 at 9:17 pm

    #968134

    Check the "Automatically set I/O affinity mask for all processors" in your server properties. We had unselected this to reduce processors for licensing, and the maintenance plan failed the following weekend and since. I reselected thsi and the plan started working. Still sounds like a bug Microsoft should fix as a plan shouldn't fail for this reason.

  • June 21, 2010 at 7:59 am

    #1182736

    I had the same problem and checked every conceivable log and even did profiler traces to no avail.

    I finally stumbled onto a solution that at least worked for me. It had to do with enabling AWE (Address Windowing Extensions allow 32-bit operating systems to access large amounts of memory. One first has to enable the lock pages in memory option. See links below. Hope this helps.

    http://msdn2.microsoft.com/en-US/library/ms190730.aspx

    http://msdn.microsoft.com/en-us/library/ms190673%28SQL.90%29.aspx

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply