July 27, 2017 at 6:17 am
GilaMonster - Wednesday, July 26, 2017 1:38 PMCan your try the following please?
Restore the damaged backup to a test server
Identify what table is object_id 1106115727
Drop that table
Then run CheckDB (without a repair option) and post whatever errors it returns
So, instead of running repair as you did, restore a backup and check this please.
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
July 27, 2017 at 7:35 am
GilaMonster - Thursday, July 27, 2017 6:17 AMGilaMonster - Wednesday, July 26, 2017 1:38 PMCan your try the following please?
Restore the damaged backup to a test server
Identify what table is object_id 1106115727
Drop that table
Then run CheckDB (without a repair option) and post whatever errors it returnsSo, instead of running repair as you did, restore a backup and check this please.
Gail,
I'm sorry ... Don't understand what you mean.
Already did what you said in the previous post.
There is no table with object_id 1106115727
What table should I drop?
July 27, 2017 at 1:05 pm
You said that after getting the error in the upgrade you ran CheckDB with the repair_rebuild option.
I'm asking you to restore a backup from *before* you ran that repair, identify which table has id 1106115727, try dropping it and then seeing what errors checkDB finds (not using any of the repair options)
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
July 27, 2017 at 2:25 pm
Gail, looking back at his response to my suggestion, it looks like the corruption exists in previous backups.
July 27, 2017 at 3:00 pm
Lynn Pettis - Thursday, July 27, 2017 2:25 PMGail, looking back at his response to my suggestion, it looks like the corruption exists in previous backups.
I'm well aware of that.
I'm trying to see whether dropping the table before/instead of running repair results in a clean DB afterwards
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
July 28, 2017 at 12:54 am
GilaMonster - Thursday, July 27, 2017 1:05 PMYou said that after getting the error in the upgrade you ran CheckDB with the repair_rebuild option.I'm asking you to restore a backup from *before* you ran that repair, identify which table has id 1106115727, try dropping it and then seeing what errors checkDB finds (not using any of the repair options)
Gail,
I did exactly that.
I restored a backup from a week ago (before repair, before upgrade... before everything).
The table with object _id 1106115727 does not exist in sys.objects.
So I can´t drop it. Correct?
As I see it there are records in sys.columns referencing an object that does not exist. And that is what is causing the inconsistency. Am I correct in this reasoning?
Thank you
July 28, 2017 at 12:59 am
Lynn Pettis - Thursday, July 27, 2017 2:25 PMGail, looking back at his response to my suggestion, it looks like the corruption exists in previous backups.
Lynn,
Yes. Correct.
July 28, 2017 at 1:36 am
joliveira 19841 - Friday, July 28, 2017 12:53 AMGilaMonster - Thursday, July 27, 2017 1:05 PMYou said that after getting the error in the upgrade you ran CheckDB with the repair_rebuild option.I'm asking you to restore a backup from *before* you ran that repair, identify which table has id 1106115727, try dropping it and then seeing what errors checkDB finds (not using any of the repair options)
Gail,
I did exactly that.
I restored a backup from a week ago (before repair, before upgrade... before everything).
The table with object _id 1106115727 does not exist in sys.objects.
So I can´t drop it. Correct?
As I see it there are records in sys.columns referencing an object that does not exist. And that is what is causing the inconsistency. Am I correct in this reasoning?
Can you run CheckDB without any repair, with the NO_INFOMSGS option and post the results?
I want to see what was wrong before the repair_rebuild fixed anything.
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
July 28, 2017 at 2:17 am
GilaMonster - Friday, July 28, 2017 1:36 AMjoliveira 19841 - Friday, July 28, 2017 12:53 AMGilaMonster - Thursday, July 27, 2017 1:05 PMYou said that after getting the error in the upgrade you ran CheckDB with the repair_rebuild option.I'm asking you to restore a backup from *before* you ran that repair, identify which table has id 1106115727, try dropping it and then seeing what errors checkDB finds (not using any of the repair options)
Gail,
I did exactly that.
I restored a backup from a week ago (before repair, before upgrade... before everything).
The table with object _id 1106115727 does not exist in sys.objects.
So I can´t drop it. Correct?
As I see it there are records in sys.columns referencing an object that does not exist. And that is what is causing the inconsistency. Am I correct in this reasoning?Can you run CheckDB without any repair, with the NO_INFOMSGS option and post the results?
I want to see what was wrong before the repair_rebuild fixed anything.
Here it is...
****************************
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=1) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=2) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=3) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=4) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=5) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=6) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=7) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=8) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=9) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=10) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=11) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=12) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=13) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=14) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=15) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=16) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=17) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=18) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=19) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=20) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=21) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=22) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=23) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=24) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=25) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=26) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=27) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=28) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=29) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=30) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=31) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=32) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=33) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=34) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=35) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=36) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=37) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=38) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=39) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=40) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=41) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=42) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=43) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=44) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=45) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=46) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=47) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=48) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=49) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=50) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=51) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=52) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=53) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=54) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=55) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=56) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=57) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=58) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=59) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=60) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=61) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=62) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=63) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=64) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=65) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=66) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=67) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=68) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=69) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=70) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=71) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=72) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=73) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=1122115784) of row (object_id=1122115784,index_id=0) in sys.indexes does not have a matching row (object_id=1122115784) in sys.objects.
CHECKDB found 0 allocation errors and 74 consistency errors not associated with any single object.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'sys.sysidxstats' (ID 54). 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:
Msg 8955, Level 16, State 1, Line 1
Data row (1:9031:4) identified by (id = 1122115784 and indid = 0) with index values 'name = NULL and id = 1122115784 and indid = 0'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysidxstats' (object ID 54).
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1323151759, index ID 1, partition ID 368189050388480, alloc unit ID 368189050388480 (type In-row data). Keys out of order on page (1:51516), slots 196 and 197.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1323151759, index ID 22, partition ID 72057594113294336, alloc unit ID 72057594112835584 (type In-row data). The previous link (1:22458) on page (1:33589) does not match the previous page (1:10982) that the parent (1:32591), slot 82 expects for this page.
Msg 8937, Level 16, State 1, Line 1
Table error: Object ID 1323151759, index ID 22, partition ID 72057594113294336, alloc unit ID 72057594112835584 (type In-row data). B-tree page (1:33589) has two parent nodes (0:1), slot 0 and (1:21438), slot 16.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1323151759, index ID 22, partition ID 72057594113294336, alloc unit ID 72057594112835584 (type In-row data). B-tree chain linkage mismatch. (1:10982)->next = (1:33589), but (1:33589)->Prev = (1:22458).
Msg 8934, Level 16, State 3, Line 1
Table error: Object ID 1323151759, index ID 22, partition ID 72057594113294336, alloc unit ID 72057594112835584 (type In-row data). The high key value on page (1:10982) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:33589).
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1323151759, index ID 22, partition ID 72057594113294336, alloc unit ID 72057594112835584 (type In-row data). Page (1:35332) is missing a reference from previous page (1:33589). Possible chain linkage problem.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1323151759, index ID 1, partition ID 368189050388480, alloc unit ID 368189050388480 (type In-row data). The previous link (1:55496) on page (1:54579) does not match the previous page (1:54728) that the parent (1:51516), slot 198 expects for this page.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1323151759, index ID 1, partition ID 368189050388480, alloc unit ID 368189050388480 (type In-row data). Index node page (1:51516), slot 197 refers to child page (1:54728) and previous child (1:55496), but they were not encountered.
CHECKDB found 0 allocation errors and 8 consistency errors in table 'LinhasCompras' (object ID 1323151759).
CHECKDB found 0 allocation errors and 83 consistency errors in database 'XXXXXX'.
July 28, 2017 at 2:32 am
Oh this is going to be a bloody pain to fix. 🙁
How big is the DB?
To be honest, it may be simpler to move everything over to a new DB and drop this one, than try to fix all those system table errors.
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
July 28, 2017 at 5:21 am
GilaMonster - Friday, July 28, 2017 2:32 AMOh this is going to be a bloody pain to fix. 🙁How big is the DB?
To be honest, it may be simpler to move everything over to a new DB and drop this one, than try to fix all those system table errors.
Hi Gail!
It's a small database.
Your idea is perhaps the best
Thank you for your help
July 28, 2017 at 6:02 am
joliveira 19841 - Friday, July 28, 2017 5:21 AMGilaMonster - Friday, July 28, 2017 2:32 AMOh this is going to be a bloody pain to fix. 🙁How big is the DB?
To be honest, it may be simpler to move everything over to a new DB and drop this one, than try to fix all those system table errors.Hi Gail!
It's a small database.
Your idea is perhaps the bestThank you for your help
Cool (and thanks, I don't really have the time to do the research needed to help fix those errors at the moment)
Script all objects, users.
Export the data (bcp out, or the import/export wizard, don't script it)
Create a new DB, create the objects, import the data.
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
Viewing 12 posts - 16 through 26 (of 26 total)
You must be logged in to reply to this topic. Login to reply