I have the following job scheduled in my sql server 6.5 managed taks area:
SQLMAINT.EXE -D trecs -CkDBNoIdx -CkAlNoIdx -Rpt e:\MSSQL\LOG\trecs_maint.rpt
It always fails with this message repeated several times (only with different allocation pages values) in the log file:
Extent not within segment: Object 240003886, indid 0 includes extents on allocation page 1985024 which is not in segment 1.
The SQL Server log has this in it several times as well:
extent 1985032 is in the wrongsegment
How do I resolve these errors?