SQLMaint job fails with error in SQL 6.5 - TechRepublic
General discussion
October 26, 2000 at 05:23 AM
lschneider

SQLMaint job fails with error in SQL 6.5

by lschneider . Updated 25 years, 6 months ago

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?

This discussion is locked

All Comments