Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-28 : 09:29:44
|
Duncan writes "I am running SQL7 Service pack 2 on a WIN2K Cluster.
I set up a maintenance plan using the MSSQL7 database maintenance plan wizard.
The wizard created three distinct jobs - for the Integrity Checking Job I had checked:
Check database integrity, and
Attempt to repair any minor problems.
Virtually every day the job fails, generating the following error message,
"sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
I can't find anything relevant when searching MS Support with that error, other than Service Pack 3 will keep the database from converting to SingleUser mode when the error occurs.
Please solve this annoying mystery. " |
|
|
|
|
|
Error on Integrity Checks Maint. Job