Indice corrupto en la tabla sysjobhistory de la bd MSDB

- July 29, 2010

Si se está presentando el siguiente error en SQL Server

Data row does not have a matching index row in the index 'nc1'

Unable to find index entry in index ID 1, of table 149575571, in database 'msdb'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.

Una solución es restaurar utilizando un respaldo o recrear el índice nuevamente por medio del siguiente script

USE [msdb]
GO

CREATE NONCLUSTERED INDEX [nc1] ON [dbo].[sysjobhistory]
(
[job_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

Saludos,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP