Page allocation issue - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Page allocation issue

Author

Topic

nytdba
Starting Member

4 Posts

Posted - 2008-05-19 : 09:51:26

Hi all,
I am running SQL 2000 Enterprise SP4 on Windows Server 2003 Standard SP2

I 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 = 0x9
bspin = 0 bnext = 0x00000000

PAGE HEADER:
------------

Page @0x73F40000
----------------
m_pageId = (1:53888) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0
m_objId = 402100473 m_indexId = 0 m_prevPage = (1:50311)
m_nextPage = (1:53890) pminlen = 579 m_slotCnt = 0
m_freeCnt = 8096 m_freeData = 7688 m_reservedCnt = 0
m_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 ALLOCATED
PFS (1:48528) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGED
ML (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.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-19 : 12:22:35

How recent is your last backup?
How long have you been getting this error?

--
Gail Shaw

nytdba
Starting Member

4 Posts

Posted - 2008-05-19 : 12:59:24

I do full backup every night. Just got this error today.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-19 : 22:50:29

Can try bcp data out, recreate table then bcp data in. Ensure backup is good.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-20 : 02:48:05

The usual recomendation for corruption is to restore a backup.

If you have tranlog backups running, backup the tail of the log and set the DB into recovering, then restore last night's full backup and tran log backups since then.

I would suggest first you restore last night's full somewhere else and run a checkDB on in, make sure the corruption isn't present.

--
Gail Shaw

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources