Optimization and Integrity question

Hi,
I have set up a database maintenance plan for all the databases on a server
that takes care of the Optimization and Integrity every week on the weekends
.
However, it's been failing consistently for the past couple of weeks. This i
s
how it's been set up:
FOR OPTIMIZATIONS
Reorganize data and index pages
Reorganize pages with the original amount of free space
and for INTEGRITY CHECKS
Check Database Integrity
Include Indexes
This is the message in the error log file for optimizations:
(null)
(null)
[16] Database TestMS: Index Rebuild (leaving 100%% free space)...
(null)
(null)
(null)
Rebuilding indexes for table 'tblData'
(null)
(null)
** Execution Time: 0 hrs, 0 mins, 1 secs **
(null)
(null)
End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:48:31 PM
(null)
SQLMAINT.EXE Process Exit Code: 1 (Failed)
(null)
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
and this is the message in the error log file for Integrity:
(null)
(null)
[16] Database TestMS: Check Data and Index Linkage...
(null)
(null)
** Execution Time: 0 hrs, 0 mins, 1 secs **
(null)
(null)
End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:56:25 PM
(null)
SQLMAINT.EXE Process Exit Code: 1 (Failed)
(null)
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
Any help will be greatly appreciated. Thanks.These are just some ideas:
1)Check to see none of the dbs upon which you are attempting this
maintenance plan are either : corrupt or off line
2)Check the compatibility levels are to low
3)Hard disk full
Jack Vamvas
___________________________________
Need an IT job? <a href="http://links.10026.com/?link=http://www.itjobfeed.com">uk it jobs</a>
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:C9D6FB45-77F3-418F-8508-0439665AFFE4@.microsoft.com...
> Hi,
> I have set up a database maintenance plan for all the databases on a
> server
> that takes care of the Optimization and Integrity every week on the
> weekends.
> However, it's been failing consistently for the past couple of weeks. This
> is
> how it's been set up:
> FOR OPTIMIZATIONS
> Reorganize data and index pages
> Reorganize pages with the original amount of free space
> and for INTEGRITY CHECKS
> Check Database Integrity
> Include Indexes
> This is the message in the error log file for optimizations:
>
> (null)
> (null)
> [16] Database TestMS: Index Rebuild (leaving 100%% free space)...
>
> (null)
> (null)
> (null)
> Rebuilding indexes for table 'tblData'
> (null)
> (null)
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
> (null)
> (null)
> End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:48:31 PM
>
> (null)
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> (null)
> Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
>
> and this is the message in the error log file for Integrity:
>
> (null)
> (null)
> [16] Database TestMS: Check Data and Index Linkage...
>
> (null)
> (null)
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
> (null)
> (null)
> End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:56:25 PM
>
> (null)
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> (null)
> Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
> Any help will be greatly appreciated. Thanks.
>