Post reply

Integrity job failed

  • July 15, 2009 at 12:54 pm

    #95827

    What is this error mean? My integrity job failed

    Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

  • July 15, 2009 at 1:46 pm

    #1025328

    It doesn't mean anything. You need to enable logging in the maintenance plan and then examine the text file log. The SQL Agent log is useless.

  • July 16, 2009 at 6:37 am

    #1025574

    How you do that? Thank you

  • July 16, 2009 at 9:49 am

    #1025744

    I found the history and this is what I have [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.

    why is that?

  • July 16, 2009 at 9:55 am

    #1025752

    You've got the 'automatically fix minor errors' option checked. Uncheck it, no job should automatically be running a repair statement, it's a stupid option that fortunately was removed in SQL 2005.

    Also run this in that DB and post the results here.

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 16, 2009 at 11:53 am

    #1025821

    I ran and there is no errors Thank you

Viewing 6 posts - 1 through 5 (of 5 total)

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