Integrity check job fails: sqlmaint.exe SQLSTATE 4200, Error 22029

Integrity check job fails with message sqlmaint.exe [SQLSTATE 4200] [Error 22029]. The step failed.
snilesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
0
 
snilesAuthor Commented:
Good stuff there.  Following those instructions I found a message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.".

This clearly points to why it's failing and what I have to do.

Thanks so much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.