Errors when rebuilding indexes

We have SQL Server 2005 set up and we are seeing the following error messages
in our logs from Daily maintenance Plan.
Please comment on the severity of these errors.
Thanks,
mkb
================================================
Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE =
OFF )
" failed with the following error: "SQL Server detected a logical
consistency-based I/O error: incorrect pageid (expected 1:2676; actual
14616:395852048). It occurred during a read of page (1:2676) in database ID
13 at offset 0x000000014e8000 in file 'C:\\Program Files\\Microsoft SQL
Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_W ebApp.mdf'. Additional
messages in the SQL Server error log or system event log may provide more
detail. This is a severe error condition that threatens database integrity
and must be corrected immediately. Complete a full database consistency check
(DBCC CHECKDB). This error can be caused by many factors; for more
information, see SQL Server Books Online.
The statement has been terminated.". Possible failure reasons: Problems with
the query, "ResultSet" property not set correctly, parameters not set
correctly, or connection not established correctly.
================================================== =
Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
REORGANIZE WITH ( LOB_COMPACTION = OFF )
" failed with the following error: "SQL Server detected a logical
consistency-based I/O error: incorrect pageid (expected 1:2653; actual
47686:707280961). It occurred during a read of page (1:2653) in database ID
13 at offset 0x000000014ba000 in file 'C:\\Program Files\\Microsoft SQL
Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_W ebApp.mdf'. Additional
messages in the SQL Server error log or system event log may provide more
detail. This is a severe error condition that threatens database integrity
and must be corrected immediately. Complete a full database consistency check
(DBCC CHECKDB). This error can be caused by many factors; for more
information, see SQL Server Books Online.". Possible failure reasons:
Problems with the query, "ResultSet" property not set correctly, parameters
not set correctly, or connection not established correctly.
================================================== ==
Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "An internal error occurred in DBCC that
prevented further processing. Contact Customer Support Services.
Check terminated. A failure was detected while collecting facts. Possibly
tempdb out of space or a system table is inconsistent. Check previous
errors.". Possible failure reasons: Problems with the query, "ResultSet"
property not set correctly, parameters not set correctly, or connection not
established correctly.
================================================== =
Hi
It seems that there is some corruption in the database. Have you had any
hardware issues? Is there any other information in the SQL Server log or
Windows Event Logs?
You could try dropping the index and running DBCC CHECKDB again. If it works
then re-create the index and run it again. If you don't find out what caused
this then it could happen again.
John
"MKBOBBA" wrote:

> We have SQL Server 2005 set up and we are seeing the following error messages
> in our logs from Daily maintenance Plan.
> Please comment on the severity of these errors.
> Thanks,
> mkb
> ================================================
> Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
> REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
> ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE =
> OFF )
> " failed with the following error: "SQL Server detected a logical
> consistency-based I/O error: incorrect pageid (expected 1:2676; actual
> 14616:395852048). It occurred during a read of page (1:2676) in database ID
> 13 at offset 0x000000014e8000 in file 'C:\\Program Files\\Microsoft SQL
> Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_W ebApp.mdf'. Additional
> messages in the SQL Server error log or system event log may provide more
> detail. This is a severe error condition that threatens database integrity
> and must be corrected immediately. Complete a full database consistency check
> (DBCC CHECKDB). This error can be caused by many factors; for more
> information, see SQL Server Books Online.
> The statement has been terminated.". Possible failure reasons: Problems with
> the query, "ResultSet" property not set correctly, parameters not set
> correctly, or connection not established correctly.
>
> ================================================== =
> Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
> REORGANIZE WITH ( LOB_COMPACTION = OFF )
> " failed with the following error: "SQL Server detected a logical
> consistency-based I/O error: incorrect pageid (expected 1:2653; actual
> 47686:707280961). It occurred during a read of page (1:2653) in database ID
> 13 at offset 0x000000014ba000 in file 'C:\\Program Files\\Microsoft SQL
> Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_W ebApp.mdf'. Additional
> messages in the SQL Server error log or system event log may provide more
> detail. This is a severe error condition that threatens database integrity
> and must be corrected immediately. Complete a full database consistency check
> (DBCC CHECKDB). This error can be caused by many factors; for more
> information, see SQL Server Books Online.". Possible failure reasons:
> Problems with the query, "ResultSet" property not set correctly, parameters
> not set correctly, or connection not established correctly.
> ================================================== ==
> Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
> " failed with the following error: "An internal error occurred in DBCC that
> prevented further processing. Contact Customer Support Services.
> Check terminated. A failure was detected while collecting facts. Possibly
> tempdb out of space or a system table is inconsistent. Check previous
> errors.". Possible failure reasons: Problems with the query, "ResultSet"
> property not set correctly, parameters not set correctly, or connection not
> established correctly.
> ================================================== =
>
|||And I forgot to add.. Make sure you have a good backup before doing this! You
could try restoring a backup on a different machine to try your tests out
before working on live (providing you have the hardware!)
John
"MKBOBBA" wrote:

> We have SQL Server 2005 set up and we are seeing the following error messages
> in our logs from Daily maintenance Plan.
> Please comment on the severity of these errors.
> Thanks,
> mkb
> ================================================
> Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
> REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
> ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE =
> OFF )
> " failed with the following error: "SQL Server detected a logical
> consistency-based I/O error: incorrect pageid (expected 1:2676; actual
> 14616:395852048). It occurred during a read of page (1:2676) in database ID
> 13 at offset 0x000000014e8000 in file 'C:\\Program Files\\Microsoft SQL
> Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_W ebApp.mdf'. Additional
> messages in the SQL Server error log or system event log may provide more
> detail. This is a severe error condition that threatens database integrity
> and must be corrected immediately. Complete a full database consistency check
> (DBCC CHECKDB). This error can be caused by many factors; for more
> information, see SQL Server Books Online.
> The statement has been terminated.". Possible failure reasons: Problems with
> the query, "ResultSet" property not set correctly, parameters not set
> correctly, or connection not established correctly.
>
> ================================================== =
> Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
> REORGANIZE WITH ( LOB_COMPACTION = OFF )
> " failed with the following error: "SQL Server detected a logical
> consistency-based I/O error: incorrect pageid (expected 1:2653; actual
> 47686:707280961). It occurred during a read of page (1:2653) in database ID
> 13 at offset 0x000000014ba000 in file 'C:\\Program Files\\Microsoft SQL
> Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_W ebApp.mdf'. Additional
> messages in the SQL Server error log or system event log may provide more
> detail. This is a severe error condition that threatens database integrity
> and must be corrected immediately. Complete a full database consistency check
> (DBCC CHECKDB). This error can be caused by many factors; for more
> information, see SQL Server Books Online.". Possible failure reasons:
> Problems with the query, "ResultSet" property not set correctly, parameters
> not set correctly, or connection not established correctly.
> ================================================== ==
> Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
> " failed with the following error: "An internal error occurred in DBCC that
> prevented further processing. Contact Customer Support Services.
> Check terminated. A failure was detected while collecting facts. Possibly
> tempdb out of space or a system table is inconsistent. Check previous
> errors.". Possible failure reasons: Problems with the query, "ResultSet"
> property not set correctly, parameters not set correctly, or connection not
> established correctly.
> ================================================== =
>