Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nytdba
Starting Member
4 Posts |
 Posted - 2008-05-19 : 09:26:18
|
| Hi all,I am running SQL 2000 Enterprise SP4 on Windows Server 2003 Standard SP2I am getting the follow error message:Table error: Page (1:53888) allocated to object ID 546100986, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.I check the hardware and didn't see any issues.I run the following command to check the actual page: dbcc traceon (3604)dbcc PAGE ([Statistics], 1, 53888, 1)Here is the output:PAGE: (1:53888)---------------BUFFER:-------BUF @0x015D7A00---------------bpage = 0x73F40000 bhash = 0x00000000 bpageno = (1:53888)bdbid = 19 breferences = 1 bstat = 0x9bspin = 0 bnext = 0x00000000 PAGE HEADER:------------Page @0x73F40000----------------m_pageId = (1:53888) m_headerVersion = 1 m_type = 1m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0m_objId = 402100473 m_indexId = 0 m_prevPage = (1:50311)m_nextPage = (1:53890) pminlen = 579 m_slotCnt = 0m_freeCnt = 8096 m_freeData = 7688 m_reservedCnt = 0m_lsn = (3643:60824:142) m_xactReserved = 0 m_xdesId = (0:26032361)m_ghostRecCnt = 0 m_tornBits = 67108866 Allocation Status-----------------GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATEDPFS (1:48528) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGEDML (1:7) = NOT MIN_LOGGED DATA:-----OFFSET TABLE:-------------DBCC execution completed. If DBCC printed error messages, contact your system administrator.Please let me know what else I can do or check in order to eliminate this error.Thank you,T. |
|
|
nytdba
Starting Member
4 Posts |
Posted - 2008-05-19 : 09:53:00
|
| Sorry, I posted it in the wrong place.I reposed it under SQL 2000 AdministrationT. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Page Allocation error message