I have a SQL2008R2 database that was mirrored. I was about to run some scripts to update some tables, SPs etc, but these were failing with
"An inconsistency was detected during an internal operation. Please contact technical support".
Various attempts at manually updating some of the tables failed, and although I'm happily able to query all data, I can't make any config changes. Any attempt to alter a table, SP, or other object result in the message
"Msg 211, Level 23, State 51, Line 1
Possible schema corruption. Run DBCC CHECKCATALOG"
This includes DBCC CHECKDB, and I've even tried setting to single-user mode and using the repair options, but all result in the same message. To compound the problem, the only backup I have also contains the corruption.
Any ideas? Thanks in advance for any suggestions...