October 2, 2013 at 8:00 am
the dbcc checkcatalog, returns follow:
Msg 3852, Level 16, State 1, Line 1
Row (object_id=717531377) in sys.objects (type=U ) does not have a matching row (object_id=717531377,index_id=0) in sys.indexes.
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=749531491) of row (object_id=749531491,index_id=0) in sys.indexes does not have a matching row (object_id=749531491) in sys.objects.
Msg 3855, Level 16, State 1, Line 1
Attribute (data_space_id=4) exists without a row (object_id=749531491,index_id=0) in sys.indexes.
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=749531491) of row (object_id=749531491,index_id=2) in sys.indexes does not have a matching row (object_id=749531491) in sys.objects.
Msg 3855, Level 16, State 1, Line 1
Attribute (data_space_id=4) exists without a row (object_id=749531491,index_id=2) in sys.indexes.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
the checkdb and checktable commands not works!
my doubt: It's possible alter system tables in SQL Server 2K8 R2 (or others alternatives) or I just to follow Microsoft's recommendation: http://support.microsoft.com/kb/2787112/en-us
October 2, 2013 at 9:49 am
If that was one of my ciients' databases, I'd be scripting, exporting and recreating it. Probably someone hacked the system tables back when that was a SQL 2000 database and hence there are no clean backups any longer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2013 at 10:47 am
I already waited for this confirmation!
thanks, Gail!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply