HI

I have set up a maintenance job using SQL Server 2000 std.=20
Ed. SP2 maintenance plans.

I want to check the Integrity (including indexes) with the=20
minor repair option turned on.=20

The job fails (I have tried to turn off minor repair and=20
exclude indexes from the check) with error:

Executed as user: XXX\YYYY. sqlmaint.exe failed. [SQLSTATE=20
42000] (Error 22029). The step failed.

I have tried issueing the following statement on the=20
database:

DBCC CHECKDB (<DB NAME>, FAST_REPAIR) WITH ALL_ERRORMSGS

(and a couple of other DBCC statements) and all returns=20
telling me that nothing is wrong with the database.

All other jobs (statistics update, full backup, translog=20
backup etc. are executing fine with no errors)

Can anyone help me?

(I cant find the error code in BOL or on the MS site)

Thank you

Jakob Persson
M=E6rsk Data AS
Denmark

Report this post to a moderator