Database got corrupted in production server

Can any one help me how to fix this issue.I dosent have good backup and we dont know when it got currupted and what would be the cause of corruption...

How to resolve this issue..

Msg 8909, Level 16, State 1, Line 100

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -6195265155596812288 (type Unknown), page ID (1:773501) contains an incorrect page ID in its page header. The PageId in the page header = (0:-2147483136).

Msg 8939, Level 16, State 98, Line 100

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -65536 (type Unknown), page (65535:-1). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -10.

Msg 8939, Level 16, State 98, Line 100

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 347556534148923392 (type Unknown), page (44801:30707024). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -1.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:23712) could not be processed.  See other errors for details.

Msg 8939, Level 16, State 98, Line 100

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:773494). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773495) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773496) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773497) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773498) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773499) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773500) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773501) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:829891) could not be processed.  See other errors for details.

Msg 8939, Level 16, State 98, Line 100

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:829891). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:829895) could not be processed.  See other errors for details.

Msg 8939, Level 16, State 98, Line 100

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:829895). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:829896) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:829897) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:833373) could not be processed.  See other errors for details.

Msg 8939, Level 16, State 98, Line 100

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:833373). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:833374) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:833375) could not be processed.  See other errors for details.

Msg 8928, Level 16, State 1, Line 100

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:920835) could not be processed.  See other errors for details.

Msg 8939, Level 16, State 98, Line 100

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:920835). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.

CHECKDB found 0 allocation errors and 72 consistency errors in table 'zzzzz' (object ID 165575628).

CHECKDB found 0 allocation errors and 112 consistency errors in database 'xxxx'.

April 17th, 2014 4:18am

Hello,

This clearly points to fact that pages in database are corrupted.Since you dont have backup you can try repair options.Remember possibility of data loss in repair option is high so be ready with consequences.This is where backups are very handy and no matter what is your enviroenment you should take atleast a full backup.

Try below code

ALTER DATABASE DB_NAME SET SINGLE_USER;
go
DBCC CHECKDB (Db_Name, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS
I am sure issue lies with underlying storage here please get it analyzed ASAP.I am not sure that there could be alternate method to solve this ( without running repair) and I guess best answer can be provided by Paul Randal himself.
Free Windows Admin Tool Kit Click here and download it now
April 17th, 2014 4:41am

Backups are scheduled but we havent run checkdb on this database we come to now this corruption issue twodays back.. and we are assuming that database got couurpted long back..
April 17th, 2014 4:45am

Backups are scheduled but we havent run checkdb on this database we come to now this corruption issue twodays back.. and we are assuming that database got couurpted long back..

Ok we have a command to check backup onsistency as well.Just assuming your backup size is not vast.Below will check consistenyc of backup but only restore guarantess that backup set is *consistent* in all possible ways.Can you run this for few backup sets you have and see which one comes out clean.Please hold with repair option lets see if we can get consistent backup we would restore from it.

http://technet.microsoft.com/en-us/library/ms188902.aspx

restore verifyonly from disk='backup_location'

Free Windows Admin Tool Kit Click here and download it now
April 17th, 2014 4:55am

By checking below links, you will be cleared about the scenario of database corruption and resolving the issue as well :

http://blogs.msdn.com/b/suhde/archive/2009/04/08/introduction-to-database-corruption-in-sql-server.aspx

http://sqlmag.com/blog/sql-server-database-corruption-part-ii-simulating-corruption

April 17th, 2014 5:27am

safer side have taken backup and restored into a test server  and executeed

ALTER DATABASE DB_NAME SET SINGLE_USER;
go
DBCC CHECKDB
(Db_Name, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS

and i have got the follwoing result it seem the issue wont solve with repai_allow_data_loss

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -6195265155596812288 (type Unknown), page ID (1:773501) contains an incorrect page ID in its page header. The PageId in the page header = (0:-2147483136).

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 5, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -308815395437150208 (type Unknown), page (1:773496). Test (m_headerVersion == HEADER_7_0) failed. Values are 42 and 1.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 8, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -308815395437150208 (type Unknown), page (1:773496). Test (m_freeCnt <= PAGESIZE - PageHeaderOverhead ()) failed. Values are 46459 and 8096.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 11, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -308815395437150208 (type Unknown), page (1:773496). Test (m_ghostRecCnt <= m_slotCnt) failed. Values are 86 and 0.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -65536 (type Unknown), page (65535:-1). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.

        Repairing this error requires other errors to be corrected first.

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:66403) contains an incorrect page ID in its page header. The PageId in the page header = (115:2128932).

        Repairing this error requires other errors to be corrected first.

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:66406) contains an incorrect page ID in its page header. The PageId in the page header = (125:2128932).

        Repairing this error requires other errors to be corrected first.

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:96547) contains an incorrect page ID in its page header. The PageId in the page header = (115:2128931).

        Repairing this error requires other errors to be corrected first.

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:96550) contains an incorrect page ID in its page header. The PageId in the page header = (125:2128931).

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 5, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page (1:728416). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 6, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page (1:728416). Test ((m_type >= DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 0.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 7, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page (1:728416). Test (m_freeData >= PageHeaderOverhead () && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.

        Repairing this error requires other errors to be corrected first.

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:833374) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 5, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474977431552 (type Unknown), page (1:66400). Test (m_headerVersion == HEADER_7_0) failed. Values are 53 and 1.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 6, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474977431552 (type Unknown), page (1:66400). Test ((m_type >= DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 0.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 7, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474977431552 (type Unknown), page (1:66400). Test (m_freeData >= PageHeaderOverhead () && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and -48666.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 10, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474977431552 (type Unknown), page (1:66400). Test (m_slotCnt < MaxSlot) failed. Values are 28429 and 4048.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 5, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474977431552 (type Unknown), page (1:96544). Test (m_headerVersion == HEADER_7_0) failed. Values are 53 and 1.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 6, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474977431552 (type Unknown), page (1:96544). Test ((m_type >= DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 0.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 7, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474977431552 (type Unknown), page (1:96544). Test (m_freeData >= PageHeaderOverhead () && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and -48666.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 10, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474977431552 (type Unknown), page (1:96544). Test (m_slotCnt < MaxSlot) failed. Values are 28429 and 4048.

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474979856384 (type Unknown), page ID (1:66409) contains an incorrect page ID in its page header. The PageId in the page header = (15433:2128932).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474979856384 (type Unknown), page ID (1:96553) contains an incorrect page ID in its page header. The PageId in the page header = (15433:2128931).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281614498332672 (type Unknown), page ID (1:96545) contains an incorrect page ID in its page header. The PageId in the page header = (47833:2603).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281614498332672 (type Unknown), page ID (1:96548) contains an incorrect page ID in its page header. The PageId in the page header = (19285:1387).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281614498332672 (type Unknown), page ID (1:96551) contains an incorrect page ID in its page header. The PageId in the page header = (62879:2421).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281614498398208 (type Unknown), page ID (1:66401) contains an incorrect page ID in its page header. The PageId in the page header = (47833:2603).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281614498398208 (type Unknown), page ID (1:66404) contains an incorrect page ID in its page header. The PageId in the page header = (19285:1387).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281614498398208 (type Unknown), page ID (1:66407) contains an incorrect page ID in its page header. The PageId in the page header = (62879:2421).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 282875346812928 (type Unknown), page ID (1:728419) contains an incorrect page ID in its page header. The PageId in the page header = (0:10485760).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 285873025122304 (type Unknown), page ID (1:829897) contains an incorrect page ID in its page header. The PageId in the page header = (256:369099008).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 562949952372736 (type Unknown), page ID (1:728417) contains an incorrect page ID in its page header. The PageId in the page header = (2600:2552).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 30680776637218816 (type Unknown), page ID (1:773499) contains an incorrect page ID in its page header. The PageId in the page header = (0:2409).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 30680776637218816 (type Unknown), page ID (1:773500) contains an incorrect page ID in its page header. The PageId in the page header = (0:2409).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 30680776928198656 (type Unknown), page ID (1:773497) contains an incorrect page ID in its page header. The PageId in the page header = (0:2409).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 30680776928198656 (type Unknown), page ID (1:773498) contains an incorrect page ID in its page header. The PageId in the page header = (0:2409).

        Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 33214051718594560 (type Unknown), page ID (1:773495) contains an incorrect page ID in its page header. The PageId in the page header = (0:2409).

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 180350571097620480 (type Unknown), page (9731:-136082096). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 347556534148923392 (type Unknown), page (44801:30707024). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2153283571949764608 (type Unknown), page (0:0). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2153283571949764608 (type Unknown), page (0:0). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 5059280147908460544 (type Unknown), page (25961:1667853423). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 5619084960249806848 (type Unknown), page (1:66408). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 5619084960249806848 (type Unknown), page (1:96552). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 5799651157634973696 (type Unknown), page (1:4). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -14.

        The repair level on the DBCC statement caused this repair to be bypassed.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 6792554138027687936 (type Unknown), page (0:0). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 6792554138027687936 (type Unknown), page (0:0). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7453175908321460224 (type Unknown), page (0:0). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -12.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7710290107034501120 (type Unknown), page (1:829896). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10.

        Repairing this error requires other errors to be corrected first.

CHECKDB found 0 allocation errors and 49 consistency errors not associated with any single object.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 55, index ID 1, partition ID 281474980315136, alloc unit ID 281474980315136 (type In-row data), page ID (1:477810) contains an incorrect page ID in its page header. The PageId in the page header = (128:32001).

        Repairing this error requires other errors to be corrected first.

CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysiscols' (object ID 55).

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:23712) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:23712). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:25182) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:25182). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:32721) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:32721). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:32722) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:32723) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66399) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:66399). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66400) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66401) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66402) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66403) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66404) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66405) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66406) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66407) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66408) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:66409) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96543) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:96543). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96544) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96545) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96546) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96547) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96548) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96549) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96550) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96551) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96552) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:96553) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:139062) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:139062). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:139063) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:477809) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:477809). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:477810) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:728415) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:728415). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:728416) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:728417) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:728418) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:728419) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:732229) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:732229). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:732230) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:752907) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:752907). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:753324) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:753324). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773494) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:773494). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773495) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773496) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773497) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773498) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773499) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773500) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:773501) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:829891) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:829891). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:829895) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:829895). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:829896) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:829897) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:833373) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:833373). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:833374) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:833375) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8928, Level 16, State 1, Line 1

Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data): Page (1:920835) could not be processed.  See other errors for details.

        Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 165575628, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039959552 (type In-row data), page (1:920835). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.

        Repairing this error requires other errors to be corrected first.

CHECKDB found 0 allocation errors and 72 consistency errors in table 'YYYYYYY' (object ID 165575628).

CHECKDB found 0 allocation errors and 122 consistency errors in database 'XXXXXXX'.


Free Windows Admin Tool Kit Click here and download it now
April 17th, 2014 6:01am

I am afraid you are correct.repir_allow_data_loss is not of any help here.Did you checked consistency of the backups ? Did you found any one clean.
April 17th, 2014 6:16am

I have confirmed that there is no backup with out corruption.

Free Windows Admin Tool Kit Click here and download it now
April 17th, 2014 6:23am

I have confirmed that there is no backup with out corruption.

You have option of restoring corrupt backup with continue_after_error.Try restoring each backup on test with this option

http://technet.microsoft.com/en-us/library/ms190952(v=sql.105).aspx

Then run checkdb with repair allow data loss to see if repair_allow_data_loss  is able to repair database.Start from oldest backup you have.

Other option is you create a new database on test machine ,take scripts of all tables/indexes/contriants  from corrupted database and create same table structure on test database .Then move data from corrupted database to new one using SSIS or import export wizard.Leave table which has corrupted data.After movement is done run checkdb on newly created database ,see if it comes out clean.

In sys.objects search for object ID mentioned in you post correlate which table is actually corrupted.

Apart from this I dont think you have valid options.Or I would suggest opeing case with Microsoft.

April 17th, 2014 7:02am

Shanky,

Is it possible to export the corrupted table except the corruped rows... and i would like to know you that in this corrupted table there is no index..


  • Edited by RoyalM 20 hours 56 minutes ago
Free Windows Admin Tool Kit Click here and download it now
April 17th, 2014 9:36am

Shanky,

Is it possible to export the corrupted table except the corruped rows... and i would like to know you that in this corrupted table there is no index..


You will need to specifically write query for selective row with where clause but since you dont have index its a heap with distributed data, its really difficult to analyze which page holding the row is corrupted. You can do select top 100 or like that .Justa guess work .If you can get that it would be commendable job.First just go with data export leaving the corrupted table,create new DB on test move data and run checkdb .If it comes clean restore the backup on prod and make db online and connect app to check how things are going.Meanwhile parallely you can continue your testing.
April 17th, 2014 9:52am

Please post the results of SELECT @@VERSION.

These kind of problems are extremely rare.  They can be caused by problems in the database engine.  However, they are almost always related to some kind of disk write error, write cache error or some other kind of problem.

Free Windows Admin Tool Kit Click here and download it now
April 17th, 2014 9:56am

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) 
Apr  2 2010 15:48:46 
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
April 18th, 2014 1:13am

I suggest you to try Stellar Phoenix SQL database repair software and perform the repair operation on the test database. Software will thoroughly scan the corrupt database file and list all the database object in the left panel for preview. you can see if the data you want to recovered or not.

Detailed information of the software is available here: http://www.stellarinfo.com/sql-recovery.htm

Good Luck!!!

Free Windows Admin Tool Kit Click here and download it now
April 18th, 2014 2:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics