February 24, 2014 at 1:02 am
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
February 24, 2014 at 1:31 am
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
February 24, 2014 at 1:52 am
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