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
 General SQL Server Forums
 New to SQL Server Programming
 Check DB failed.

Author  Topic 

pjsathish
Starting Member

2 Posts
Posted - 2007-11-16 : 06:18:04
Hi

I am a SAP Basis Administrator. One of the job has failed miserably that deals with the MSSQL database.

The error message is been pasted below:

Executed as user: NT AUTHORITY\SYSTEM. ...ile: C:Program Files\Microsoft SQL Server\MSSQL\CCMS_CHEC
K_DB_HIST_2007.txt [SQLSTATE 01000] (Message 50000
) Table error: Object ID 0, index ID 0, page (1:2
881160). Test (m_headerVersion == HEADER_7_0) fail
ed. Values are 0 and 1. [SQLSTATE 42000] (Error 89
39) Table error: Object ID 0, index ID 0, page (1
:2881160). Test ((m_type >=DATA_PAGE && m_type <=
UNDOFILE_HEADER_PAGE) (m_type == UNKNOWN_PAGE &
& level == BASIC_HEADER)) failed. Values are 0 and
101. [SQLSTATE 42000] (Error 8939) Table error:
Object ID 0, index ID 0, page (1:2881160). Test (m
_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)P
AGESIZE - m_slotCnt * sizeof (Slot)) failed. Value
s are 0 and 8192. [SQLSTATE 42000] (Error 8939) T
able error: Object ID 0, index ID 0, page ID (1:28
81161). The PageId in the page header = (0:0). [SQ
LSTATE 42000] (Error 8909) Table error: Object ID
0, index ID 0, page ID (1:2881162). The PageId in
the page header = (0:0). [SQLSTATE 42000] (Error
8... The step failed.

Please let me know how to rectify the error.



Sathish

pjsathish
Starting Member

2 Posts
Posted - 2007-11-16 : 06:50:23
Adding to that, plz find below the error messages found in the SQL server log file:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Msg 8939, Sev 16: Table error: Object ID 0, index ID 0, page (1:2881160). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 0, index ID 0, page (1:2881160). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 0, index ID 0, page (1:2881160). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881161). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881162). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881163). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881164). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881165). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881166). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881167). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 0, index ID 0, page (1:2881168). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 0, index ID 0, page (1:2881168). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 0, index ID 0, page (1:2881168). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881169). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881170). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881171). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881172). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881173). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881174). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881175). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 0, index ID 0, page (1:2881176). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 0, index ID 0, page (1:2881176). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 0, index ID 0, page (1:2881176). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881177). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:2881178). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 0: Page (1:2881160) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 0: Page (1:2881161) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 0: Page (1:2881162) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 0: Page (1:2881163) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 0: Page (1:2881164) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 0: Page (1:2881165) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 0: Page (1:2881166) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 0: Page (1:2881167) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 3: Page (1:2881168) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 3: Page (1:2881169) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 3: Page (1:2881170) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 3: Page (1:2881171) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 3: Page (1:2881172) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 3: Page (1:2881173) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 3: Page (1:2881174) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 3: Page (1:2881175) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 6: Page (1:2881176) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 6: Page (1:2881177) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 530699026, index ID 6: Page (1:2881178) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8954, Sev 16: CHECKDB found 0 allocation errors and 25 consistency errors not associated with any single object. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 19 consistency errors in table 'DD03L' (object ID 530699026). [SQLSTATE 01000]
Msg 8989, Sev 16: CHECKDB found 0 allocation errors and 44 consistency errors in database 'DEV'. [SQLSTATE 01000]
Msg 8958, Sev 16: repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DEV ). [SQLSTATE 01000]

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DBCC CHECKDB (DEV) finished at Nov 16 2007 1:18AM

It contains all the information required.

Please let me know how to resolve this.


Sathish
Go to Top of Page

anonymous1
Posting Yak Master

185 Posts
Posted - 2007-11-16 : 09:20:31
start by looking at CHECKDB or CHECKTABLE using the REPAIR_ALLOW_DATA_LOSS option
http://msdn2.microsoft.com/en-us/library/aa258278(SQL.80).aspx
next you need to find the source of the corruption to prevent reoccurence
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site