SQL 2000 SP4 logical page belongs to XX, not to YY

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

SQL 2000 SP4 logical page belongs to XX, not to YY

Author

Topic

Bauwensk
Starting Member

4 Posts

Posted - 2012-04-16 : 08:16:16

Hello,

We've had this problem already a few times, a restore always helps, but I keep wondering why this problem keeps reappearing...

The error shows when trying to reindex a table:

dbcc dbreindex('amutak')
Msg 605, Level 21, State 1, Line 1
Attempt to fetch logical page (1:17938) in database '331' belongs to object 'gbkmut', not to object 'amutak'.

When I do a checktable I get a lot of errors:

dbcc CHECKTABLE('amutak')
DBCC results for 'amutak'.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17938) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17939) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17940) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17941) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17942) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17943) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17952) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17953) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17954) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17955) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17956) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17957) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17958) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:17959) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18042) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18043) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18044) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18045) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18046) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18047) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18048) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18049) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18050) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18051) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18052) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:18053) allocated to object ID 1979154096, index ID 0 was not seen.  Page may be invalid or have incorrect object ID information in its header.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Page (1:17938) was not seen in the scan although its parent (1:17921) and previous (1:17937) refer to it. Check any previous errors.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 18 refers to child page (1:17939) and previous child (1:17938), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 19 refers to child page (1:17940) and previous child (1:17939), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 20 refers to child page (1:17941) and previous child (1:17940), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 21 refers to child page (1:17942) and previous child (1:17941), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 22 refers to child page (1:17943) and previous child (1:17942), but they were not encountered.
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17944) (level 0) is not less than the low key value in the parent (1:17921), slot 24 of the next page (1:17945).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. The previous link (1:17903) on page (1:17944) does not match the previous page (1:17943) that the parent (1:17921), slot 23 expects for this page.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Page (1:17944) is missing a reference from previous page (1:17903). Possible chain linkage problem.
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17945) (level 0) is not less than the low key value in the parent (1:17921), slot 25 of the next page (1:17946).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17946) (level 0) is not less than the low key value in the parent (1:17921), slot 26 of the next page (1:17947).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17947) (level 0) is not less than the low key value in the parent (1:17921), slot 27 of the next page (1:17948).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17948) (level 0) is not less than the low key value in the parent (1:17921), slot 28 of the next page (1:17949).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17949) (level 0) is not less than the low key value in the parent (1:17921), slot 29 of the next page (1:17950).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17950) (level 0) is not less than the low key value in the parent (1:17921), slot 30 of the next page (1:17951).
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 31 refers to child page (1:17952) and previous child (1:17951), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 32 refers to child page (1:17953) and previous child (1:17952), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 33 refers to child page (1:17954) and previous child (1:17953), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 34 refers to child page (1:17955) and previous child (1:17954), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 35 refers to child page (1:17956) and previous child (1:17955), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 36 refers to child page (1:17957) and previous child (1:17956), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 37 refers to child page (1:17958) and previous child (1:17957), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 38 refers to child page (1:17959) and previous child (1:17958), but they were not encountered.
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17960) (level 0) is not less than the low key value in the parent (1:17921), slot 40 of the next page (1:17961).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. The previous link (1:17951) on page (1:17960) does not match the previous page (1:17959) that the parent (1:17921), slot 39 expects for this page.
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17961) (level 0) is not less than the low key value in the parent (1:17921), slot 41 of the next page (1:17962).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17962) (level 0) is not less than the low key value in the parent (1:17921), slot 42 of the next page (1:17963).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17963) (level 0) is not less than the low key value in the parent (1:17921), slot 43 of the next page (1:17964).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17964) (level 0) is not less than the low key value in the parent (1:17921), slot 44 of the next page (1:17965).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17965) (level 0) is not less than the low key value in the parent (1:17921), slot 45 of the next page (1:17966).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:17966) (level 0) is not less than the low key value in the parent (1:17921), slot 46 of the next page (1:17967).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:18024) (level 0) is not less than the low key value in the parent (1:17921), slot 96 of the next page (1:18025).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. The previous link (1:17967) on page (1:18024) does not match the previous page (1:18015) that the parent (1:17921), slot 95 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. B-tree chain linkage mismatch. (1:18015)->next = (1:18024), but (1:18024)->Prev = (1:17967).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1979154096, index ID 1. The high key value on page (1:18025) (level 0) is not less than the low key value in the parent (1:17921), slot 97 of the next page (1:18026).
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Page (1:18042) was not seen in the scan although its parent (1:17921) and previous (1:18041) refer to it. Check any previous errors.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 114 refers to child page (1:18043) and previous child (1:18042), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 115 refers to child page (1:18044) and previous child (1:18043), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 116 refers to child page (1:18045) and previous child (1:18044), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 117 refers to child page (1:18046) and previous child (1:18045), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 118 refers to child page (1:18047) and previous child (1:18046), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 119 refers to child page (1:18048) and previous child (1:18047), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 120 refers to child page (1:18049) and previous child (1:18048), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 121 refers to child page (1:18050) and previous child (1:18049), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 122 refers to child page (1:18051) and previous child (1:18050), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 123 refers to child page (1:18052) and previous child (1:18051), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Index node page (1:17921), slot 124 refers to child page (1:18053) and previous child (1:18052), but they were not encountered.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1979154096, index ID 1. Page (1:18054) is missing a reference from previous page (1:18053). Possible chain linkage problem.
There are 7629 rows in 783 pages for object 'amutak'.
CHECKTABLE found 0 allocation errors and 74 consistency errors in table 'amutak' (object ID 1979154096).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (331.dbo.amutak ).

checkCatalog gives nothing

DBCC CHECKCATALOG ('331')
DBCC results for '331'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

The server is SQL Server 2000 SP4 running on Windows server 2003 R2 (Hyper V virtualized)
I can't seem to find any problems with the hard disks..
I have no idea what might be causing this error.

Can anybody help me with finding the origin of this error?
Kind regards,
Koen

prett
Posting Yak Master

212 Posts

Posted - 2012-04-17 : 04:27:24

Hello Koen,

The DBCC printed error messages occur due to two reasons either there is some issue with database page or a problem with the SQL Server engine which determines the expected allocation unit.

In this case if DBCC CHECKDB or CHECKTABLE reports an error which you have already tried then there is possibility that page is damaged or an incorrect page. To resolve this issue you should restore from a backup. If you don't have backup then use repair options with DBCC CHECKDB. If these solutions are still unsuccessful, then you can try SQL Recovery Software. You can do Googling it like this: http://lmgtfy.com/?q=sql+repair+software

Reference: http://support.microsoft.com/kb/2015739

Bauwensk
Starting Member

4 Posts

Posted - 2012-04-17 : 05:19:21

I tried the repair options and some errors get solved, but most errors didn't.
So we will restore from a backup.

Thank you for the help.

Is there any way to prevent this from happening again?
We run daily integrity checks, but apparently that is not enough...

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2012-04-17 : 05:45:15

can you confirm that you don't get the problem after restore? Just to make sure your backup sets don't contain the broken page(s)

There are some real experts on the subject here -- Someone will post some indepth help I'm sure.

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

Bauwensk
Starting Member

4 Posts

Posted - 2012-04-17 : 06:41:16

I can confirm this. Did the same checks after the restore.

Bauwensk
Starting Member

4 Posts

Posted - 2012-05-03 : 02:33:59

We are having errors again. This time on another table, but the same database.

DBCC results for 'BankTransactions'.
Msg 8928, Level 16, State 1, Line 1
Object ID 1264723558, index ID 17: Page (1:76171) could not be processed. See other errors for details.
Msg 8941, Level 16, State 102, Line 1
Table error: Object ID 1264723558, index ID 17, page (1:76171). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 144, offset 0x20 is invalid.
Msg 8942, Level 16, State 101, Line 1
Table error: Object ID 1264723558, index ID 17, page (1:76171). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x90 overlaps with the prior row.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76172) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76173) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 84 refers to child page (1:76173) and previous child (1:76172), but they were not encountered.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76174) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 85 refers to child page (1:76174) and previous child (1:76173), but they were not encountered.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76175) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 86 refers to child page (1:76175) and previous child (1:76174), but they were not encountered.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76176) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 87 refers to child page (1:76176) and previous child (1:76175), but they were not encountered.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76177) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 88 refers to child page (1:76177) and previous child (1:76176), but they were not encountered.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76178) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 89 refers to child page (1:76178) and previous child (1:76177), but they were not encountered.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76179) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 90 refers to child page (1:76179) and previous child (1:76178), but they were not encountered.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76180) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 91 refers to child page (1:76180) and previous child (1:76179), but they were not encountered.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76181) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 92 refers to child page (1:76181) and previous child (1:76180), but they were not encountered.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:76182) allocated to object ID 1264723558, index ID 17 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Index node page (1:76058), slot 93 refers to child page (1:76182) and previous child (1:76181), but they were not encountered.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 17. Page (1:76183) is missing a reference from previous page (1:76182). Possible chain linkage problem.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:833) allocated to object ID 1264723558, index ID 43 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 43. Page (1:833) was not seen in the scan although its parent (1:834) and previous (1:832) refer to it. Check any previous errors.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:835) allocated to object ID 1264723558, index ID 43 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 43. Index node page (1:834), slot 2 refers to child page (1:835) and previous child (1:833), but they were not encountered.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 43. Page (1:836) is missing a reference from previous page (1:835). Possible chain linkage problem.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:852) allocated to object ID 1264723558, index ID 43 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 43. Page (1:852) was not seen in the scan although its parent (1:834) and previous (1:851) refer to it. Check any previous errors.
Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:853) allocated to object ID 1264723558, index ID 43 was not seen. Page may be invalid or have incorrect object ID information in its header.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 43. Index node page (1:834), slot 20 refers to child page (1:853) and previous child (1:852), but they were not encountered.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1264723558, index ID 43. Page (1:854) is missing a reference from previous page (1:853). Possible chain linkage problem.
There are 34355 rows in 2944 pages for object 'BankTransactions'.
CHECKDB found 0 allocation errors and 35 consistency errors in table 'BankTransactions' (object ID 1264723558).

We are going to move this database to another partition to see if its a disk problem.
But this is unlikely I think because this is a virtualized server...
I'll update when I have more news..

granuharmot
Starting Member

31 Posts

Posted - 2014-09-23 : 05:07:33

unspammed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources