Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2556
  • Last Modified:

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.
0
sniles
Asked:
sniles
1 Solution
 
Guy Hengel [angelIII / a3]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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now