question

lianvh avatar image
lianvh asked

Missing indexes in sys.sysclsobjs for sql server 2014

Good day, I ran the dbcc checkdb on the system database master and the message

"missing index for the table Table error: table 'sys.sysclsobjs' (ID 64). Data row does not have a matching index row in the index 'nc' (ID 2). Possible missing or invalid keys for the index row matching" . Bu there is no table in master called 'sys.sysclsobjs'. Any ideas ?


sql-serversystem-databasessystem-tables
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

So, two way street here. What did you end up doing?
0 Likes 0 ·
anthony.green avatar image
anthony.green answered

Thats a system base table, usually only accessible by Microsoft people.

If you have support with MS I'd recommend raising a case, otherwise your into rebuilding the system databases and with that being master make sure you have backups of everything, databases, logins, jobs, you name it anything you have on that server you need to script it / back it up before you even attempt to rebuild master.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SmithSean avatar image
SmithSean answered

If you have good backup then restore from it.

I will suggest not to use Repair_Allow_data_loss option. You can try any tool to repair the DB. Check this review: https://www.scarydba.com/2020/09/23/review-stellar-repair-for-sql-server/

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.