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 ?
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.
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/
20 People are following this question.
