November 22, 2005 at 10:37 am
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????????????????
November 22, 2005 at 11:53 am
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.....
November 22, 2005 at 7:12 pm
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://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=128881&p=1
Hope this helps!
Martin
November 23, 2005 at 9:58 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply