Tuesday, February 14, 2012

CheckDB error

This is the first time i get an error for DBCC checkdb run
I checked my HDD and it is perfect. Kindly give me an
alternate solutions
See this o/p error:
Server: Msg 7995, Level 16, State 1, Line 1
Database 'blc' consistency errors in sysobjects, sysindexes, syscolumns, or
systypes prevent further CHECKDB processing.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:129) in database ID 28 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
50_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:130) in database ID 28 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'IAM_PG MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:714) in database ID 28 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:793) in database ID 28 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:945) in database ID 28 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:987) in database ID 28 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:1278) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'IAM_PG MIXED_EXT
ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:1755) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:1758) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:1760) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:1761) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
100_PCT_FULL'.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:2344) in database ID 28 is marked allocated in the GAM, but no
SGAM or IAM has allocated it.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:2792) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3129) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3130) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3134) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3135) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3144) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 2511, Level 16, State 1, Line 1
Table Corrupt: Object ID 2, Index ID 0. Keys out of order on page (1:2432),
slots 3 and 4.
DBCC results for 'blc'.
CHECKDB found 18 allocation errors and 0 consistency errors not associated
with any single object.
There are 758 rows in 39 pages for object 'sysindexes'.
CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysindexes' (object ID 2).
CHECKDB found 18 allocation errors and 1 consistency errors in database
'blc'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (blc ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
First, with everyone off the database, run DBCC checkdb again to ensure it
was not a transient error caused by multiple users making changes during the
original run...
If the errors go away - no problem.
If the errors are reported again, prepare to restore from backup... Open a
Call to Microsoft PSS as well, they may be able to help you...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"RV.Krishnan" <krish@.rsi.ramco.com> wrote in message
news:%23Hx2qtuaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> This is the first time i get an error for DBCC checkdb run
> I checked my HDD and it is perfect. Kindly give me an
> alternate solutions
> See this o/p error:
> --
> Server: Msg 7995, Level 16, State 1, Line 1
> Database 'blc' consistency errors in sysobjects, sysindexes, syscolumns,
or
> systypes prevent further CHECKDB processing.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:129) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 50_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:130) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1),
> but was not allocated in any IAM. PFS flags 'IAM_PG MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:714) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 100_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:793) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 100_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:945) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:987) in database ID 28 is allocated in the SGAM (1:3) and PFS
(1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 100_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:1278) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'IAM_PG MIXED_EXT
> ALLOCATED 0_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:1755) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 100_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:1758) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 100_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:1760) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 100_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:1761) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 100_PCT_FULL'.
> Server: Msg 8905, Level 16, State 1, Line 1
> Extent (1:2344) in database ID 28 is marked allocated in the GAM, but no
> SGAM or IAM has allocated it.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:2792) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:3129) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:3130) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:3134) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:3135) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:3144) in database ID 28 is allocated in the SGAM (1:3) and PFS
> (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table Corrupt: Object ID 2, Index ID 0. Keys out of order on page
(1:2432),
> slots 3 and 4.
> DBCC results for 'blc'.
> CHECKDB found 18 allocation errors and 0 consistency errors not associated
> with any single object.
> There are 758 rows in 39 pages for object 'sysindexes'.
> CHECKDB found 0 allocation errors and 1 consistency errors in table
> 'sysindexes' (object ID 2).
> CHECKDB found 18 allocation errors and 1 consistency errors in database
> 'blc'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKDB (blc ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>

No comments:

Post a Comment