I attached a base and when initiating the system appears the following
message: Error 823
I/O error <error> detected during <operation> at offset <offset> in file
'<file>'
Executei dbcc checkdb and showed some errors, executed dbcc checkdb with
repair_rebuild, but it did not correct with error (The repair level on the
DBCC statement caused this repair to be bypassed. The system cannot self
repair this error.)
It has another possibility to correct?
And I do not have backup brought up to data.If you don't have a backup then you're only option is to run checkedb with
the REPAIR_ALLOW_DATA_LOSS option. Note that this will break the
transactional consistency of relationships between tables and so on. If
you're unsure how to proceed you should contact PSS who will walk you
through it (http://support.microsoft.com/)
Regards
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carla" <Carla@.discussions.microsoft.com> wrote in message
news:3A6CAEB4-B4DC-48BB-B6AE-67B6979DB453@.microsoft.com...
> I attached a base and when initiating the system appears the following
> message: Error 823
> I/O error <error> detected during <operation> at offset <offset> in file
> '<file>'
> Executei dbcc checkdb and showed some errors, executed dbcc checkdb with
> repair_rebuild, but it did not correct with error (The repair level on the
> DBCC statement caused this repair to be bypassed. The system cannot self
> repair this error.)
> It has another possibility to correct?
> And I do not have backup brought up to data.|||Hi,
I used to REPAIR_ALLOW_DATA_LOSS, but i continued with the same errors.
This is end the error
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object
ID 1094862163)' (object ID 1094862163).
The system cannot self repair this error.
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object
ID 1229017694)' (object ID 1229017694).
CHECKDB found 62 allocation errors and 1 consistency errors in database
'itlsys'.
Help me
"Paul S Randal [MS]" wrote:
> If you don't have a backup then you're only option is to run checkedb with
> the REPAIR_ALLOW_DATA_LOSS option. Note that this will break the
> transactional consistency of relationships between tables and so on. If
> you're unsure how to proceed you should contact PSS who will walk you
> through it (http://support.microsoft.com/)
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Carla" <Carla@.discussions.microsoft.com> wrote in message
> news:3A6CAEB4-B4DC-48BB-B6AE-67B6979DB453@.microsoft.com...
> >
> > I attached a base and when initiating the system appears the following
> > message: Error 823
> > I/O error <error> detected during <operation> at offset <offset> in file
> > '<file>'
> > Executei dbcc checkdb and showed some errors, executed dbcc checkdb with
> > repair_rebuild, but it did not correct with error (The repair level on the
> > DBCC statement caused this repair to be bypassed. The system cannot self
> > repair this error.)
> > It has another possibility to correct?
> > And I do not have backup brought up to data.
>
>|||Can you post the actual errors it found please?
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carla" <Carla@.discussions.microsoft.com> wrote in message
news:8C62BD23-7200-4E44-9133-C72ED17DD359@.microsoft.com...
> Hi,
> I used to REPAIR_ALLOW_DATA_LOSS, but i continued with the same errors.
> This is end the error
> CHECKDB found 1 allocation errors and 0 consistency errors in table
'(Object
> ID 1094862163)' (object ID 1094862163).
> The system cannot self repair this error.
> CHECKDB found 1 allocation errors and 0 consistency errors in table
'(Object
> ID 1229017694)' (object ID 1229017694).
> CHECKDB found 62 allocation errors and 1 consistency errors in database
> 'itlsys'.
> Help me
>
> "Paul S Randal [MS]" wrote:
> > If you don't have a backup then you're only option is to run checkedb
with
> > the REPAIR_ALLOW_DATA_LOSS option. Note that this will break the
> > transactional consistency of relationships between tables and so on. If
> > you're unsure how to proceed you should contact PSS who will walk you
> > through it (http://support.microsoft.com/)
> >
> > Regards
> >
> > --
> > Paul Randal
> > Dev Lead, Microsoft SQL Server Storage Engine
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Carla" <Carla@.discussions.microsoft.com> wrote in message
> > news:3A6CAEB4-B4DC-48BB-B6AE-67B6979DB453@.microsoft.com...
> > >
> > > I attached a base and when initiating the system appears the following
> > > message: Error 823
> > > I/O error <error> detected during <operation> at offset <offset> in
file
> > > '<file>'
> > > Executei dbcc checkdb and showed some errors, executed dbcc checkdb
with
> > > repair_rebuild, but it did not correct with error (The repair level on
the
> > > DBCC statement caused this repair to be bypassed. The system cannot
self
> > > repair this error.)
> > > It has another possibility to correct?
> > > And I do not have backup brought up to data.
> >
> >
> >|||Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:323520) has invalid PFS_PAGE page header
values. Type is 0. Check type, object ID and page ID on the page.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID -2130691967, index ID 18764, page (1:323520). Test
(IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID -2130691967, index ID 18764, page (1:323520). Test
(IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8921, Level 16, State 1, Line 1
CHECKTABLE terminated. A failure was detected while collecting facts.
Possibly tempdb out of space or a system table is inconsistent. Check
previous errors.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:299256) to (1:307343). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:307344) to (1:315431). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:315432) to (1:323519). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:323520) to (1:331607). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:331608) to (1:339695). See other errors for cause.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:339696). Test (m_headerVersion
== HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:339696). Test ((m_type
>=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE &&
level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:339696). Test (m_freeData >=PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot))
failed. Values are 0 and 8192.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:339696) to (1:347783). See other errors for cause.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:347784). Test (m_headerVersion
== HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:347784). Test ((m_type
>=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE &&
level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:347784). Test (m_freeData >=PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot))
failed. Values are 0 and 8192.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:347784) to (1:355871). See other errors for cause.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:355872). Test (m_headerVersion
== HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:355872). Test ((m_type
>=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE &&
level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:355872). Test (m_freeData >=PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot))
failed. Values are 0 and 8192.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:355872) to (1:363959). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:363960) to (1:372047). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:372048) to (1:380135). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:380136) to (1:388223). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:388224) to (1:396311). See other errors for cause.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:396312). Test (m_headerVersion
== HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:396312). Test ((m_type
>=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE &&
level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:396312). Test (m_freeData >=PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot))
failed. Values are 0 and 8192.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:396312). Test (*(((int*)
&m_reservedB) + i) == 0) failed. Values are 0 and 892941614.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:396312) to (1:404399). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:404400) to (1:412487). See other errors for cause.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:412488) to (1:420575). See other errors for cause.
The system cannot self repair this error.
The system cannot self repair this error.
CHECKDB found 1 allocation errors and 1 consistency errors in table '(Object
ID -2130691967)' (object ID -2130691967).
DBCC results for 'itlsys'.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be
bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be
bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 7 pages from (1:420576) to (1:428663). See other errors for cause.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 8224, page (1:412488). Test
(m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 8224, page (1:412488). Test ((m_type
>=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE &&
level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 8224, page (1:412488). Test (m_freeData
>= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot))
failed. Values are 0 and 8192.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 8224, page (1:412488). Test (*(((int*)
&m_reservedB) + i) == 0) failed. Values are 0 and 791763761.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1160, index ID 8224, page (1:380136). Test
(m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1160, index ID 8224, page (1:380136). Test (m_slotCnt
< MaxSlot) failed. Values are 10240 and 4048.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1160, index ID 8224, page (1:380136). Test (*(((int*)
&m_reservedB) + i) == 0) failed. Values are 1 and -1207959552.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 50345345, index ID 18764, page (1:315432). Test
(IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976288, index ID 8224, page (1:363960). Test
(m_headerVersion == HEADER_7_0) failed. Values are 53 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976288, index ID 8224, page (1:363960). Test
(m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt *
sizeof (Slot)) failed. Values are 0 and -8256.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976288, index ID 8224, page (1:363960). Test
(m_slotCnt < MaxSlot) failed. Values are 8224 and 4048.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976288, index ID 8224, page (1:363960). Test
(*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 538976288.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976288, index ID 8224, page (1:388224). Test
(m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976288, index ID 8224, page (1:388224). Test
(m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 8224 and 8096.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976288, index ID 8224, page (1:388224). Test
(m_slotCnt < MaxSlot) failed. Values are 8224 and 4048.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976288, index ID 8224, page (1:388224). Test
(*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 538976288.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976311, index ID 32, page (1:372048). Test
(m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976311, index ID 32, page (1:372048). Test
(m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 13619 and 8096.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976311, index ID 32, page (1:372048). Test
(m_slotCnt < MaxSlot) failed. Values are 8224 and 4048.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 538976311, index ID 32, page (1:372048). Test
(*(((int*) &m_reservedB) + i) == 0) failed. Values are 1 and 538976288.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 771751936, index ID 13618, page (1:420576). Test
(m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 771751936, index ID 13618, page (1:420576). Test
(*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 538976288.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 824188960, index ID 8224, page (1:404400). Test
(m_headerVersion == HEADER_7_0) failed. Values are 51 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 824188960, index ID 8224, page (1:404400). Test
(m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 8224 and 8096.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 824188960, index ID 8224, page (1:404400). Test
(m_slotCnt < MaxSlot) failed. Values are 14080 and 4048.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 824188960, index ID 8224, page (1:404400). Test
(*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 538980630.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 892418303, index ID 25966, page (1:299256). Test
(m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 892418303, index ID 25966, page (1:299256). Test
(m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt *
sizeof (Slot)) failed. Values are 14640 and 8094.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 892418303, index ID 25966, page (1:299256). Test
(m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 13614 and 8096.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 892418303, index ID 25966, page (1:299256). Test
(*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 825897010.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1094862163, index ID 18764, page (1:331608). Test
(IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
The repair level on the DBCC statement caused this repair to be
bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
CHECKDB found 33 allocation errors and 0 consistency errors not associated
with any single object.
DBCC results for 'sysobjects'.
There are 838 rows in 13 pages for object 'sysobjects'.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
CHECKDB found 3 allocation errors and 0 consistency errors in table '(Object
ID 1160)' (object ID 1160).
The system cannot self repair this error.
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object
ID 50345345)' (object ID 50345345).
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
CHECKDB found 8 allocation errors and 0 consistency errors in table '(Object
ID 538976288)' (object ID 538976288).
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
CHECKDB found 4 allocation errors and 0 consistency errors in table '(Object
ID 538976311)' (object ID 538976311).
The system cannot self repair this error.
The system cannot self repair this error.
CHECKDB found 2 allocation errors and 0 consistency errors in table '(Object
ID 771751936)' (object ID 771751936).
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
CHECKDB found 4 allocation errors and 0 consistency errors in table '(Object
ID 824188960)' (object ID 824188960).
The repair level on the DBCC statement caused this repair to be
bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
CHECKDB found 4 allocation errors and 0 consistency errors in table '(Object
ID 892418303)' (object ID 892418303).
Server: Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1229017694, index ID 18764, page (1:307344). Test
(IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
The system cannot self repair this error.
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object
ID 1094862163)' (object ID 1094862163).
The system cannot self repair this error.
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object
ID 1229017694)' (object ID 1229017694).
CHECKDB found 62 allocation errors and 1 consistency errors in database
'itlsys'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.|||Ah - you've hit one of the few page corruptions that are unrepairable - a
PFS page header. SQL Server cannot fix this error, so unless you have a
backup, your only option is to extract the data from the database into a new
database. You also need to run hardware diagnostics on your system as I'm
guessing that a portion of the PFS page has been zeroed out.
You should contact PSS to help you as this is beyond the scope of the
newsgroups.
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carla" <Carla@.discussions.microsoft.com> wrote in message
news:1F022C26-9F0B-41E0-B1D7-3CADE197E37D@.microsoft.com...
> Server: Msg 8946, Level 16, State 12, Line 2
> Table error: Allocation page (1:323520) has invalid PFS_PAGE page header
> values. Type is 0. Check type, object ID and page ID on the page.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID -2130691967, index ID 18764, page (1:323520). Test
> (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057
and -1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID -2130691967, index ID 18764, page (1:323520). Test
> (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057
and -1.
> Server: Msg 8921, Level 16, State 1, Line 1
> CHECKTABLE terminated. A failure was detected while collecting facts.
> Possibly tempdb out of space or a system table is inconsistent. Check
> previous errors.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:299256) to (1:307343). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:307344) to (1:315431). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:315432) to (1:323519). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:323520) to (1:331607). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:331608) to (1:339695). See other errors for
cause.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:339696). Test
(m_headerVersion
> == HEADER_7_0) failed. Values are 0 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:339696). Test ((m_type
> >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE
&&
> level == BASIC_HEADER)) failed. Values are 0 and 101.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:339696). Test (m_freeData >=> PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot))
> failed. Values are 0 and 8192.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:339696) to (1:347783). See other errors for
cause.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:347784). Test
(m_headerVersion
> == HEADER_7_0) failed. Values are 0 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:347784). Test ((m_type
> >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE
&&
> level == BASIC_HEADER)) failed. Values are 0 and 101.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:347784). Test (m_freeData >=> PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot))
> failed. Values are 0 and 8192.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:347784) to (1:355871). See other errors for
cause.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:355872). Test
(m_headerVersion
> == HEADER_7_0) failed. Values are 0 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:355872). Test ((m_type
> >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE
&&
> level == BASIC_HEADER)) failed. Values are 0 and 101.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:355872). Test (m_freeData >=> PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot))
> failed. Values are 0 and 8192.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:355872) to (1:363959). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:363960) to (1:372047). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:372048) to (1:380135). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:380136) to (1:388223). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:388224) to (1:396311). See other errors for
cause.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:396312). Test
(m_headerVersion
> == HEADER_7_0) failed. Values are 0 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:396312). Test ((m_type
> >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE
&&
> level == BASIC_HEADER)) failed. Values are 0 and 101.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:396312). Test (m_freeData >=> PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot))
> failed. Values are 0 and 8192.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page (1:396312). Test (*(((int*)
> &m_reservedB) + i) == 0) failed. Values are 0 and 892941614.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:396312) to (1:404399). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:404400) to (1:412487). See other errors for
cause.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:412488) to (1:420575). See other errors for
cause.
> The system cannot self repair this error.
> The system cannot self repair this error.
> CHECKDB found 1 allocation errors and 1 consistency errors in table
'(Object
> ID -2130691967)' (object ID -2130691967).
> DBCC results for 'itlsys'.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
verify
> database ID 7 pages from (1:420576) to (1:428663). See other errors for
cause.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 8224, page (1:412488). Test
> (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 8224, page (1:412488). Test ((m_type
> >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE
&&
> level == BASIC_HEADER)) failed. Values are 0 and 101.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 8224, page (1:412488). Test (m_freeData
> >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof
(Slot))
> failed. Values are 0 and 8192.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 8224, page (1:412488). Test (*(((int*)
> &m_reservedB) + i) == 0) failed. Values are 0 and 791763761.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 1160, index ID 8224, page (1:380136). Test
> (m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 1160, index ID 8224, page (1:380136). Test
(m_slotCnt
> < MaxSlot) failed. Values are 10240 and 4048.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 1160, index ID 8224, page (1:380136). Test
(*(((int*)
> &m_reservedB) + i) == 0) failed. Values are 1 and -1207959552.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 50345345, index ID 18764, page (1:315432). Test
> (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057
and -1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976288, index ID 8224, page (1:363960). Test
> (m_headerVersion == HEADER_7_0) failed. Values are 53 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976288, index ID 8224, page (1:363960). Test
> (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt *
> sizeof (Slot)) failed. Values are 0 and -8256.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976288, index ID 8224, page (1:363960). Test
> (m_slotCnt < MaxSlot) failed. Values are 8224 and 4048.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976288, index ID 8224, page (1:363960). Test
> (*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 538976288.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976288, index ID 8224, page (1:388224). Test
> (m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976288, index ID 8224, page (1:388224). Test
> (m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 8224 and 8096.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976288, index ID 8224, page (1:388224). Test
> (m_slotCnt < MaxSlot) failed. Values are 8224 and 4048.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976288, index ID 8224, page (1:388224). Test
> (*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 538976288.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976311, index ID 32, page (1:372048). Test
> (m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976311, index ID 32, page (1:372048). Test
> (m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 13619 and 8096.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976311, index ID 32, page (1:372048). Test
> (m_slotCnt < MaxSlot) failed. Values are 8224 and 4048.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 538976311, index ID 32, page (1:372048). Test
> (*(((int*) &m_reservedB) + i) == 0) failed. Values are 1 and 538976288.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 771751936, index ID 13618, page (1:420576). Test
> (m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 771751936, index ID 13618, page (1:420576). Test
> (*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 538976288.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 824188960, index ID 8224, page (1:404400). Test
> (m_headerVersion == HEADER_7_0) failed. Values are 51 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 824188960, index ID 8224, page (1:404400). Test
> (m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 8224 and 8096.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 824188960, index ID 8224, page (1:404400). Test
> (m_slotCnt < MaxSlot) failed. Values are 14080 and 4048.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 824188960, index ID 8224, page (1:404400). Test
> (*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 538980630.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 892418303, index ID 25966, page (1:299256). Test
> (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 892418303, index ID 25966, page (1:299256). Test
> (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt *
> sizeof (Slot)) failed. Values are 14640 and 8094.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 892418303, index ID 25966, page (1:299256). Test
> (m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 13614 and 8096.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 892418303, index ID 25966, page (1:299256). Test
> (*(((int*) &m_reservedB) + i) == 0) failed. Values are 0 and 825897010.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 1094862163, index ID 18764, page (1:331608). Test
> (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057
and -1.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> CHECKDB found 33 allocation errors and 0 consistency errors not associated
> with any single object.
> DBCC results for 'sysobjects'.
> There are 838 rows in 13 pages for object 'sysobjects'.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> CHECKDB found 3 allocation errors and 0 consistency errors in table
'(Object
> ID 1160)' (object ID 1160).
> The system cannot self repair this error.
> CHECKDB found 1 allocation errors and 0 consistency errors in table
'(Object
> ID 50345345)' (object ID 50345345).
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> CHECKDB found 8 allocation errors and 0 consistency errors in table
'(Object
> ID 538976288)' (object ID 538976288).
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> CHECKDB found 4 allocation errors and 0 consistency errors in table
'(Object
> ID 538976311)' (object ID 538976311).
> The system cannot self repair this error.
> The system cannot self repair this error.
> CHECKDB found 2 allocation errors and 0 consistency errors in table
'(Object
> ID 771751936)' (object ID 771751936).
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> CHECKDB found 4 allocation errors and 0 consistency errors in table
'(Object
> ID 824188960)' (object ID 824188960).
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> The system cannot self repair this error.
> The system cannot self repair this error.
> The system cannot self repair this error.
> CHECKDB found 4 allocation errors and 0 consistency errors in table
'(Object
> ID 892418303)' (object ID 892418303).
> Server: Msg 8939, Level 16, State 98, Line 1
> Table error: Object ID 1229017694, index ID 18764, page (1:307344). Test
> (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057
and -1.
> The system cannot self repair this error.
> CHECKDB found 1 allocation errors and 0 consistency errors in table
'(Object
> ID 1094862163)' (object ID 1094862163).
> The system cannot self repair this error.
> CHECKDB found 1 allocation errors and 0 consistency errors in table
'(Object
> ID 1229017694)' (object ID 1229017694).
> CHECKDB found 62 allocation errors and 1 consistency errors in database
> 'itlsys'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
