SQL2008R2 DBCC Checkdb ... contains an incorrect page ID in its page header. The PageId in the page header = (0:0)

  • 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

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

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

    - 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

  • 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, MVP, M.Sc (Comp Sci)
    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
  • Thank you for the confirmation.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

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

    - 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply