Post reply

SQL SERVER Error 22029

  • November 22, 2005 at 10:37 am

    #111519

    I just made a maintenance plan for several dbs.  I ran all the components and one failed.  The backup and the optimizations went fine, but the integrity check failed and produced the following error:

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

    Wussupwifdat???????????????? 

    Thank you!!,

    Angelindiego

  • November 22, 2005 at 11:53 am

    #605299

    Ok, now I have run DBCC CHECKDB and found that there are no allocation errors but 849 consistency errors in a specified table!!!!  GEEZ!!!  Just making sure here, but it tells me to run DBCC CHECKDB again with Repair_allow_data_loss but to put the db in SINGLE_USER mode first.....

    Does this sound right??  This is a busy demo server database and single user mode is going to cause me grief.....

    Thank you!!,

    Angelindiego

  • November 22, 2005 at 7:12 pm

    #605373

    Hi Dana,

    When you created the maintenance plan, on the "Data Integrity Check" part did you tick the "Attempt to repair any minor problems" checkbox? As far as I know, if there is anything to be fixed up then SQL Server will run DBCC CHECKDB WITH REPAIR_ALLOW_DATA_LOSS.

    And yep, DBCC CHECKDB WITH REPAIR_ALLOW_DATA_LOSS does need to be in single user mode. Please see BOL or http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_00gy.asp

    Also there's another discussion in SQLServerCentral that sounds like it might be what you're looking for:

    http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=128881&p=1

    Hope this helps!

    Martin

  • November 23, 2005 at 9:58 am

    #605498

    Thanks a ton Martin!!!  Happy Turkey Day!!!

    Thank you!!,

    Angelindiego

Viewing 4 posts - 1 through 3 (of 3 total)

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