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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-08-25 : 07:45:59
|
| Hi thereI am using "Database Maintenance Plan" on one of our database. The jobs for Optimazation and Integrity Checks are always failing and when I looked at SQL Server Log dont't realised that the failed job for optimazation and Integrity check didn't get recorded in the log (I can see the successfull jobs though). Is this normal?The generic error for both jobs that I got is in View Job History which are:Step 1: Executed as user [OUR_DOMAIN_ACC]. sqlmaint.exe failed. [SQLSTATE 42000][Error 22029]. The step is failed.Any help regarding this, I am appreciated.Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-25 : 11:51:16
|
| you need to figure out why the integrity check job is failing. One reason for this job to fail is if it finds corruption.the integrity check job is just running a DBCC CHECKDB against every database. You can fire up query analyzer and run the DBCC CHECKDB against each database manually. That will help you find out which database this step is failing on.-ec |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-08-26 : 15:49:26
|
| I ran DBCC CHECKDB (TSQL) and there is no mentioned about error on it. ?!?!Are they any different between the DBCC CheckDB and Check Database Integrity Integrity Job (as apart of "Database Maintenance Plan wizard"). I guess the only different on Database Maintenance Plan ... I thick the option of "Include Indexes" which i believe they are identical ... aren't they?Thanks |
|
|
|
|
|
|
SQL2K: Database Maintenance Plan