Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL2008R2 DBCC Checkdb ... contains an incorrect page ID in its page header. The PageId in the page header = (0:0) Expand / Collapse
Author
Message
Posted Monday, February 24, 2014 1:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:03 AM
Points: 6,748, Visits: 8,544
Hi,

After a SAN mishap last Friday, and of course this happens when one is out of the office, the post restore checkdb for one of my non-system databases resulted in a error message:

DBCC CHECKDB (mydb) WITH ALL_ERRORMSGS, EXTENDED_LOGICAL_CHECKS, NO_INFOMSGS 

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:105144) contains an incorrect page ID in its page header. The PageId in the page header = (0:0). [SQLSTATE 42000] (Error 8909) Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 15 pages from (1:105144) to (1:113231). See other errors for cause. [SQLSTATE 42000] (Error 8998) DBCC results for 'mydb'. [SQLSTATE 01000] (Error 2536) CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object. [SQLSTATE 01000] (Error 8954) CHECKDB found 2 allocation errors and 0 consistency errors in database 'mydb'. [SQLSTATE 01000] (Error 8989) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Error 2528). The step failed.


DBCC TRACEON (3604);
GO
DBCC PAGE (mydb, 1, 105144, 3);
GO
DBCC TRACEOFF (3604);
go

Result
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:105144) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).

PAGE: (0:0)


BUFFER:


BUF @0x0000000085FF61C0

bpage = 0x0000000085E5A000 bhash = 0x0000000000000000 bpageno = (1:105144)
bdbid = 15 breferences = 0 bcputicks = 0
bsampleCount = 0 bUse1 = 55833 bstat = 0xc00809
blog = 0x99999999 bnext = 0x0000000000000000

PAGE HEADER:


Page @0x0000000085E5A000

m_pageId = (0:0) m_headerVersion = 0 m_type = 0
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0
m_objId (AllocUnitId.idObj) = 0 m_indexId (AllocUnitId.idInd) = 0 Metadata: AllocUnitId = 0
Metadata: PartitionId = 0 Metadata: IndexId = -1 Metadata: ObjectId = 0
m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 0
m_slotCnt = 0 m_freeCnt = 0 m_freeData = 0
m_reservedCnt = 0 m_lsn = (0:0:0) m_xactReserved = 0
m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status

GAM (1:2) = NOT ALLOCATED SGAM (1:3) = NOT ALLOCATED PFS (1:105144) = 0x0 0_PCT_FULL
DIFF (1:6) = NOT CHANGED ML (1:7) = NOT MIN_LOGGED
Msg 2514, Level 16, State 5, Line 2
A DBCC PAGE error has occurred: Invalid page type - dump style 3 not possible.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

(208 row(s) affected)


DBCC TRACEON (3604);
GO
DBCC PAGE (mydb, 1, 105144, 2);
GO
DBCC TRACEOFF (3604);

Result
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:105144) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).

PAGE: (0:0)


BUFFER:


BUF @0x0000000085FF61C0

bpage = 0x0000000085E5A000 bhash = 0x0000000000000000 bpageno = (1:105144)
bdbid = 15 breferences = 0 bcputicks = 0
bsampleCount = 0 bUse1 = 56390 bstat = 0xc00809
blog = 0x99999999 bnext = 0x0000000000000000

PAGE HEADER:


Page @0x0000000085E5A000

m_pageId = (0:0) m_headerVersion = 0 m_type = 0
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0
m_objId (AllocUnitId.idObj) = 0 m_indexId (AllocUnitId.idInd) = 0 Metadata: AllocUnitId = 0
Metadata: PartitionId = 0 Metadata: IndexId = -1 Metadata: ObjectId = 0
m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 0
m_slotCnt = 0 m_freeCnt = 0 m_freeData = 0
m_reservedCnt = 0 m_lsn = (0:0:0) m_xactReserved = 0
m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status

GAM (1:2) = NOT ALLOCATED SGAM (1:3) = NOT ALLOCATED PFS (1:105144) = 0x0 0_PCT_FULL
DIFF (1:6) = NOT CHANGED ML (1:7) = NOT MIN_LOGGED

DATA:


Memory Dump @0x000000003210A000

000000003210A000: 00000000 00000000 00000000 00000000 †................
000000003210A010: 00000000 00000000 00000000 00000000 †................
....
000000003210BFE0: 00000000 00000000 00000000 00000000 †................
000000003210BFF0: 00000000 00000000 00000000 00000000 †................


DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.




Question:
Can this be repaired using the REPAIR_REBUILD ? ( or should I re-restore this database from an older backup ? )





Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1544378
Posted Monday, February 24, 2014 1:31 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:13 AM
Points: 40,609, Visits: 37,070
Restore from backup.

The only time repair rebuild will fix corruption is when the second-last line of the checkDB output reads "REPAIR_REBUILD is the minimum level to repair"



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1544383
Posted Monday, February 24, 2014 1:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:03 AM
Points: 6,748, Visits: 8,544
Thank you for the confirmation.



Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1544388
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse