How can i do in this urgent case? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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

Data Corruption Issues

How can i do in this urgent case?

Author

Topic

jasontsang
Starting Member

5 Posts

Posted - 2010-01-21 : 05:04:43

Our SQL2000 server is Raid 5.It make up of 3 hard disk and divide two partition.The database file is in D drive.
One of the biggest database can't be backup in normal mode in Sqlagent.And also can't be cold backup.MDF can't be copy though the sql service is stopped completely.
I excute "DBCC CHECKDB" in this database,and the log is shown below:Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (1:676976) with latch type UP. ?? failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:676977) with latch type UP. ?? failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:676978) with latch type UP. ?? failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:676979) with latch type UP. ?? failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:676980) with latch type UP. ?? failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:676981) with latch type UP. ?? failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:676982) with latch type UP. ?? failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:676983) with latch type UP. ?? failed.
DBCC results for 'EASTOP'.
CHECKDB found 0 allocation errors and 8 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 3140 rows in 57 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 1331 rows in 67 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 14427 rows in 204 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 2591 rows in 74 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 50 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 13 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 8 rows in 4 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 11349 rows in 55 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 0 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'WHADDRESS'.
There are 16 rows in 1 pages for object 'WHADDRESS'.
DBCC results for 'STOCKBAL_LOTTMP'.
There are 0 rows in 0 pages for object 'STOCKBAL_LOTTMP'.
DBCC results for 'MRP_TMPPO'.
There are 0 rows in 0 pages for object 'MRP_TMPPO'.
DBCC results for 'INVGRNQTY'.
There are 3969978 rows in 49308 pages for object 'INVGRNQTY'.
DBCC results for 'SHIPTERM'.
There are 2 rows in 1 pages for object 'SHIPTERM'.
DBCC results for 'QUOCOSTTMP'.
There are 0 rows in 0 pages for object 'QUOCOSTTMP'.
DBCC results for 'CONTACTS'.
There are 943 rows in 13 pages for object 'CONTACTS'.
DBCC results for 'ARSETTLE'.
There are 12 rows in 1 pages for object 'ARSETTLE'.
DBCC results for 'WORKTIME'.
There are 1 rows in 1 pages for object 'WORKTIME'.
DBCC results for 'GRNDSCRP'.
There are 756046 rows in 25371 pages for object 'GRNDSCRP'.
DBCC results for 'BOMMAP'.
There are 0 rows in 0 pages for object 'BOMMAP'.
DBCC results for 'ECNAMEH'.
There are 742 rows in 6 pages for object 'ECNAMEH'.
DBCC results for 'PRODUCT2'.
There are 17393 rows in 497 pages for object 'PRODUCT2'.
DBCC results for 'JOB'.
There are 5608 rows in 104 pages for object 'JOB'.
DBCC results for 'CRPPL'.
There are 0 rows in 0 pages for object 'CRPPL'.
DBCC results for 'SIZETABLE'.
There are 548 rows in 3 pages for object 'SIZETABLE'.
DBCC results for 'COSTSHEET'.
There are 0 rows in 0 pages for object 'COSTSHEET'.
DBCC results for 'ACBAL_T1C'.
There are 0 rows in 0 pages for object 'ACBAL_T1C'.
DBCC results for 'STOCKBAL_WH'.
There are 1135165 rows in 8021 pages for object 'STOCKBAL_WH'.
DBCC results for 'CRPPL1'.
There are 0 rows in 0 pages for object 'CRPPL1'.
DBCC results for 'STAFF_LOGGING'.
There are 0 rows in 0 pages for object 'STAFF_LOGGING'.
DBCC results for 'ECNAMEHEADER'.
There are 19 rows in 1 pages for object 'ECNAMEHEADER'.
DBCC results for 'MRP_TMPSC'.
There are 0 rows in 0 pages for object 'MRP_TMPSC'.
DBCC results for 'CRPPL2'.
There are 0 rows in 0 pages for object 'CRPPL2'.
DBCC results for 'ECNAMETMP'.
There are 0 rows in 1 pages for object 'ECNAMETMP'.
DBCC results for 'STEP'.
There are 0 rows in 0 pages for object 'STEP'.
DBCC results for 'PSMISCQTY'.
There are 0 rows in 0 pages for object 'PSMISCQTY'.
DBCC results for 'WUNIT'.
There are 0 rows in 0 pages for object 'WUNIT'.
DBCC results for 'DNLQTY'.
There are 85943 rows in 611 pages for object 'DNLQTY'.
DBCC results for 'CRPPL3'.
There are 0 rows in 0 pages for object 'CRPPL3'.
DBCC results for 'POMARKS'.
There are 0 rows in 0 pages for object 'POMARKS'.
DBCC results for 'MSGLOG'.
There are 617 rows in 10 pages for object 'MSGLOG'.
DBCC results for 'PRODCOST'.
There are 25 rows in 1 pages for object 'PRODCOST'.
DBCC results for 'INVLQTY'.
There are 910800 rows in 7217 pages for object 'INVLQTY'.
DBCC results for 'BOMQTY'.
There are 0 rows in 0 pages for object 'BOMQTY'.
DBCC results for 'ACBAL_T2C'.
There are 0 rows in 0 pages for object 'ACBAL_T2C'.
DBCC results for 'JOBDSCRP'.
There are 0 rows in 0 pages for object 'JOBDSCRP'.
DBCC results for 'STOCKBAL_WHTMP'.
There are 0 rows in 0 pages for object 'STOCKBAL_WHTMP'.
DBCC results for 'CURRENCYRATE'.
There are 3 rows in 1 pages for object 'CURRENCYRATE'.
DBCC results for 'ARTABLE'.
There are 3 rows in 1 pages for object 'ARTABLE'.
DBCC results for 'XAVEX_DNBFQTY'.
There are 0 rows in 0 pages for object 'XAVEX_DNBFQTY'.
DBCC results for 'MSGTXT'.
There are 429 rows in 6 pages for object 'MSGTXT'.
DBCC results for 'XQTYTABLE'.
There are 300 rows in 1 pages for object 'XQTYTABLE'.
DBCC results for 'DNQTY'.
There are 0 rows in 0 pages for object 'DNQTY'.
DBCC results for 'PRODUCTALT'.
There are 0 rows in 0 pages for object 'PRODUCTALT'.
DBCC results for 'CUSADDR'.
There are 2046 rows in 46 pages for object 'CUSADDR'.
DBCC results for 'STOCKBALTMP'.
There are 0 rows in 1 pages for object 'STOCKBALTMP'.
DBCC results for 'ASSEM'.
There are 0 rows in 0 pages for object 'ASSEM'.
DBCC results for 'ACBAL_T3C'.
There are 0 rows in 0 pages for object 'ACBAL_T3C'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:676976) allocated to object ID 310292165, index ID 2 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 310292165, index ID 2. Page (1:676976) was not seen in the scan although its parent (1:676997) and previous (1:676975) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:676977) allocated to object ID 310292165, index ID 2 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 310292165, index ID 2. Index node page (1:676997), slot 102 refers to child page (1:676977) and previous child (1:676976), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:676978) allocated to object ID 310292165, index ID 2 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 310292165, index ID 2. Index node page (1:676997), slot 103 refers to child page (1:676978) and previous child (1:676977), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:676979) allocated to object ID 310292165, index ID 2 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 310292165, index ID 2. Index node page (1:676997), slot 104 refers to child page (1:676979) and previous child (1:676978), but they were not encountered.
DBCC results for 'CUT'.
There are 0 rows in 0 pages for object 'CUT'.
DBCC results for 'INVMARKS'.
There are 0 rows in 0 pages for object 'INVMARKS'.
DBCC results for 'MSQCHK'.
There are 12 rows in 1 pages for object 'MSQCHK'.
DBCC results for 'PRODPHOTO'.
There are 620 rows in 14 pages for object 'PRODPHOTO'.
DBCC results for 'JOURBODY'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:676980) allocated to object ID 310292165, index ID 2 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 310292165, index ID 2. Index node page (1:676997), slot 105 refers to child page (1:676980) and previous child (1:676979), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:676981) allocated to object ID 310292165, index ID 2 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 310292165, index ID 2. Index node page (1:676997), slot 106 refers to child page (1:676981) and previous child (1:676980), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:676982) allocated to object ID 310292165, index ID 2 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 310292165, index ID 2. Index node page (1:676997), slot 107 refers to child page (1:676982) and previous child (1:676981), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:676983) allocated to object ID 310292165, index ID 2 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 310292165, index ID 2. Index node page (1:676997), slot 108 refers to child page (1:676983) and previous child (1:676982), but they were not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 310292165, index ID 2. Page (1:676984) is missing a reference from previous page (1:676983). Possible chain linkage problem.
There are 15147701 rows in 210039 pages for object 'JOURBODY'.
CHECKDB found 0 allocation errors and 17 consistency errors in table 'JOURBODY' (object ID 310292165).
DBCC results for 'PRODUCTSTK'.
There are 330114 rows in 2917 pages for object 'PRODUCTSTK'.
DBCC results for 'STEPLEAD'.
There are 0 rows in 0 pages for object 'STEPLEAD'.
DBCC results for 'QUODSCRP'.
There are 43 rows in 1 pages for object 'QUODSCRP'.
DBCC results for 'MRP1'.
There are 0 rows in 0 pages for object 'MRP1'.
DBCC results for 'JOURBODY_MC'.
There are 0 rows in 0 pages for object 'JOURBODY_MC'.
DBCC results for 'CUTDSCRP'.
There are 0 rows in 0 pages for object 'CUTDSCRP'.
DBCC results for 'POMISC'.
There are 54 rows in 1 pages for object 'POMISC'.
DBCC results for 'ECNCOST'.
There are 0 rows in 0 pages for object 'ECNCOST'.
DBCC results for 'ACBAL_T4C'.
There are 31745 rows in 261 pages for object 'ACBAL_T4C'.
DBCC results for 'MUNIT'.
There are 0 rows in 0 pages for object 'MUNIT'.
DBCC results for 'ASSEMDSCRP'.
There are 0 rows in 0 pages for object 'ASSEMDSCRP'.
DBCC results for 'PRODUCTSUBSTK'.
There are 0 rows in 0 pages for object 'PRODUCTSUBSTK'.
DBCC results for 'JOURHEAD'.
There are 1832505 rows in 28021 pages for object 'JOURHEAD'.
DBCC results for 'STOCKTRANS'.
There are 6351006 rows in 125652 pages for object 'STOCKTRANS'.
DBCC results for 'GRNGRP'.
There are 0 rows in 0 pages for object 'GRNGRP'.
DBCC results for 'MYCURRENCY'.
There are 3 rows in 1 pages for object 'MYCURRENCY'.
DBCC results for 'POQTY'.
There are 0 rows in 0 pages for object 'POQTY'.
DBCC results for 'ECNDSCRP'.
There are 0 rows in 0 pages for object 'ECNDSCRP'.
DBCC results for 'ACBAL_T5C'.
There are 0 rows in 0 pages for object 'ACBAL_T5C'.
DBCC results for 'JOURT4T9'.
There are 8619344 rows in 35442 pages for object 'JOURT4T9'.
DBCC results for 'STEPQTY'.
There are 0 rows in 0 pages for object 'STEPQTY'.
DBCC results for 'DAILY'.
There are 0 rows in 0 pages for object 'DAILY'.
DBCC results for 'INVMISC'.
There are 23 rows in 1 pages for object 'INVMISC'.
DBCC results for 'PACKING'.
There are 0 rows in 0 pages for object 'PACKING'.
DBCC results for 'PSOTHER'.
There are 0 rows in 0 pages for object 'PSOTHER'.
DBCC results for 'a'.
There are 7883 rows in 43 pages for object 'a'.
DBCC results for 'KEYCODE'.
There are 29 rows in 1 pages for object 'KEYCODE'.
DBCC results for 'PRODLINE'.
There are 0 rows in 0 pages for object 'PRODLINE'.
DBCC results for 'GRNGRPDSCRP'.
There are 0 rows in 0 pages for object 'GRNGRPDSCRP'.
DBCC results for 'DAILYDSCRP'.
There are 0 rows in 0 pages for object 'DAILYDSCRP'.
DBCC results for 'COSTSHEETCOST'.
There are 0 rows in 0 pages for object 'COSTSHEETCOST'.
DBCC results for 'BOMTYPE'.
There are 0 rows in 0 pages for object 'BOMTYPE'.
DBCC results for 'PSOTHERAMT'.
There are 0 rows in 0 pages for object 'PSOTHERAMT'.
DBCC results for 'ASSET'.
There are 0 rows in 0 pages for object 'ASSET'.
DBCC results for 'web09'.
There are 1110 rows in 7 pages for object 'web09'.
DBCC results for 'ACBAL_T6C'.
There are 0 rows in 0 pages for object 'ACBAL_T6C'.
DBCC results for 'NANA'.
There are 8092 rows in 44 pages for object 'NANA'.
DBCC results for 'QUOMISC'.
There are 0 rows in 0 pages for object 'QUOMISC'.
DBCC results for 'PRODLINEDSCRP'.
There are 0 rows in 0 pages for object 'PRODLINEDSCRP'.
DBCC results for 'BOOK'.
There are 0 rows in 0 pages for object 'BOOK'.
DBCC results for 'KEYCODEINV'.
There are 0 rows in 0 pages for object 'KEYCODEINV'.
DBCC results for 'INVNOMAPD'.
There are 0 rows in 0 pages for object 'INVNOMAPD'.
DBCC results for 'GRNGRPMISC'.
There are 0 rows in 0 pages for object 'GRNGRPMISC'.
DBCC results for 'SYSAUDIT'.
There are 4201153 rows in 39822 pages for object 'SYSAUDIT'.
DBCC results for 'DRSETINV'.
There are 0 rows in 0 pages for object 'DRSETINV'.
DBCC results for 'PRODLINEWORK'.
There are 0 rows in 0 pages for object 'PRODLINEWORK'.
DBCC results for 'COSTSHEETDSCRP'.
There are 0 rows in 0 pages for object 'COSTSHEETDSCRP'.
DBCC results for 'BOOKSET'.
There are 1 rows in 1 pages for object 'BOOKSET'.
DBCC results for 'PACKINGDSCRP'.
There are 0 rows in 0 pages for object 'PACKINGDSCRP'.
DBCC results for 'PSQTY'.
There are 0 rows in 0 pages for object 'PSQTY'.
DBCC results for 'ECNINFO'.
There are 0 rows in 0 pages for object 'ECNINFO'.
DBCC results for 'MRP1_TMPPO'.
There are 0 rows in 0 pages for object 'MRP1_TMPPO'.
DBCC results for 'ACBAL_T7C'.
There are 0 rows in 0 pages for object 'ACBAL_T7C'.
DBCC results for 'PRODMSALES'.
There are 275426 rows in 2691 pages for object 'PRODMSALES'.
DBCC results for 'INVNOMAPH'.
There are 0 rows in 0 pages for object 'INVNOMAPH'.
DBCC results for 'STKADJD'.
There are 359670 rows in 8217 pages for object 'STKADJD'.
DBCC results for 'QUOQTY'.
There are 0 rows in 0 pages for object 'QUOQTY'.
DBCC results for 'LINKTABLES'.
There are 0 rows in 0 pages for object 'LINKTABLES'.
DBCC results for 'TABLE2NEWDB'.
There are 12 rows in 1 pages for object 'TABLE2NEWDB'.
DBCC results for 'GRNLQTY'.
There are 145716 rows in 1314 pages for object 'GRNLQTY'.
DBCC results for 'ASSET_BOOK'.
There are 0 rows in 0 pages for object 'ASSET_BOOK'.
DBCC results for 'DRSETMISC'.
There are 0 rows in 0 pages for object 'DRSETMISC'.
DBCC results for 'LOCKINFO'.
There are 2 rows in 1 pages for object 'LOCKINFO'.
DBCC results for 'INVOICE'.
There are 1798846 rows in 80487 pages for object 'INVOICE'.
DBCC results for 'ASSET_DETAIL'.
There are 0 rows in 0 pages for object 'ASSET_DETAIL'.
DBCC results for 'PRODMSALES_ALL'.
There are 97 rows in 1 pages for object 'PRODMSALES_ALL'.
DBCC results for 'PROMOTION'.
There are 185 rows in 9 pages for object 'PROMOTION'.
DBCC results for 'ACBAL_T8C'.
There are 0 rows in 0 pages for object 'ACBAL_T8C'.
DBCC results for 'TABLES_DEPT'.
There are 21 rows in 1 pages for object 'TABLES_DEPT'.
DBCC results for 'MRP1_TMPSC'.
There are 0 rows in 0 pages for object 'MRP1_TMPSC'.
DBCC results for 'DRSETTLE'.
There are 0 rows in 0 pages for object 'DRSETTLE'.
DBCC results for 'MACHINE'.
There are 0 rows in 0 pages for object 'MACHINE'.
DBCC results for 'BOOKSLOT'.
There are 480 rows in 2 pages for object 'BOOKSLOT'.
DBCC results for 'TABLES_EXP'.
There are 0 rows in 0 pages for object 'TABLES_EXP'.
DBCC results for 'GRNMISC'.
There are 914 rows in 13 pages for object 'GRNMISC'.
DBCC results for 'PRODOEM'.
There are 14493 rows in 532 pages for object 'PRODOEM'.
DBCC results for 'BROWSERSETTINGS'.
There are 6 rows in 1 pages for object 'BROWSERSETTINGS'.
DBCC results for 'TABLES_IMP'.
There are 0 rows in 0 pages for object 'TABLES_IMP'.
DBCC results for 'ACBAL_T9C'.
There are 0 rows in 0 pages for object 'ACBAL_T9C'.
DBCC results for 'BROWSERTABLE'.
There are 709 rows in 32 pages for object 'BROWSERTABLE'.
DBCC results for 'DAILYQTY'.
There are 0 rows in 0 pages for object 'DAILYQTY'.
DBCC results for 'ABC'.
There are 82 rows in 1 pages for object 'ABC'.
DBCC results for 'STKADJD_PS'.
There are 0 rows in 0 pages for object 'STKADJD_PS'.
DBCC results for 'GRNPREPAID'.
There are 0 rows in 0 pages for object 'GRNPREPAID'.
DBCC results for 'PACKINGQTY'.
There are 0 rows in 0 pages for object 'PACKINGQTY'.
DBCC results for 'MACHINEDSCRP'.
There are 0 rows in 0 pages for object 'MACHINEDSCRP'.
DBCC results for 'TABLES_KEY'.
There are 31 rows in 1 pages for object 'TABLES_KEY'.
DBCC results for 'PRODOEM_bk_20051230'.
There are 10802 rows in 492 pages for object 'PRODOEM_bk_20051230'.
DBCC results for 'COSTSHEETQTY'.
There are 0 rows in 0 pages for object 'COSTSHEETQTY'.
DBCC results for 'DUNIT'.
There are 0 rows in 0 pages for object 'DUNIT'.
DBCC results for 'PRODOEM_bk_20060119'.
There are 10932 rows in 498 pages for object 'PRODOEM_bk_20060119'.
DBCC results for 'ASSET_RULETABLE'.
There are 0 rows in 0 pages for object 'ASSET_RULETABLE'.
DBCC results for 'ACCOUNTS'.
There are 177 rows in 3 pages for object 'ACCOUNTS'.
DBCC results for 'INVDSCRP'.
There are 4826140 rows in 146099 pages for object 'INVDSCRP'.
DBCC results for 'Results'.
There are 0 rows in 1 pages for object 'Results'.
DBCC results for 'TABLES_SUB'.
There are 35 rows in 1 pages for object 'TABLES_SUB'.
DBCC results for 'DAILYREASON'.
There are 0 rows in 0 pages for object 'DAILYREASON'.
DBCC results for 'Sheetx'.
There are 681 rows in 6 pages for object 'Sheetx'.
DBCC results for 'GRNQTY'.
There are 0 rows in 0 pages for object 'GRNQTY'.
DBCC results for 'ECN'.
There are 0 rows in 0 pages for object 'ECN'.
DBCC results for 'v4'.
There are 480 rows in 4 pages for object 'v4'.
DBCC results for 'ASSET_TRANS'.
There are 0 rows in 0 pages for object 'ASSET_TRANS'.
DBCC results for 'MRP2'.
There are 0 rows in 0 pages for object 'MRP2'.
DBCC results for 'ACCOUNTSMAP'.
There are 305 rows in 1 pages for object 'ACCOUNTSMAP'.
DBCC results for 'VH12'.
There are 31 rows in 1 pages for object 'VH12'.
DBCC results for 'STKADJH'.
There are 44380 rows in 1078 pages for object 'STKADJH'.
DBCC results for 'PSSTEP'.
There are 0 rows in 0 pages for object 'PSSTEP'.
DBCC results for 'TABLES_UPD'.
There are 59 rows in 1 pages for object 'TABLES_UPD'.
DBCC results for 'VH22'.
There are 31 rows in 1 pages for object 'VH22'.
DBCC results for 'ALLAUXUNIT'.
There are 0 rows in 0 pages for object 'ALLAUXUNIT'.
DBCC results for 'ECNQTY'.
There are 0 rows in 0 pages for object 'ECNQTY'.
DBCC results for 'MESSAGE'.
There are 7396 rows in 76 pages for object 'MESSAGE'.
DBCC results for 'TAILORFUNTCION'.
There are 2 rows in 1 pages for object 'TAILORFUNTCION'.
DBCC results for 'QUOTAT'.
There are 2 rows in 1 pages for object 'QUOTAT'.
DBCC results for 'CALENDAR'.
There are 0 rows in 0 pages for object 'CALENDAR'.
DBCC results for 'TAILORINFO'.
There are 36 rows in 1 pages for object 'TAILORINFO'.
DBCC results for 'PSWH'.
There are 0 rows in 0 pages for object 'PSWH'.
DBCC results for 'ASSORT'.
There are 0 rows in 0 pages for object 'ASSORT'.
DBCC results for 'DEBTOR_BAL'.
There are 0 rows in 0 pages for object 'DEBTOR_BAL'.
DBCC results for 'APPREPAID'.
There are 82 rows in 2 pages for object 'APPREPAID'.
DBCC results for 'CALENDARDSCRP'.
There are 0 rows in 0 pages for object 'CALENDARDSCRP'.
DBCC results for 'INVPAYMETHOD'.
There are 0 rows in 0 pages for object 'INVPAYMETHOD'.
DBCC results for 'MISCCATMAP'.
There are 0 rows in 0 pages for object 'MISCCATMAP'.
DBCC results for 'ASSORTDSCRP'.
There are 0 rows in 0 pages for object 'ASSORTDSCRP'.
DBCC results for 'TCODE'.
There are 10 rows in 1 pages for object 'TCODE'.
DBCC results for 'PREPAREPO'.
There are 0 rows in 0 pages for object 'PREPAREPO'.
DBCC results for 'QC'.
There are 0 rows in 0 pages for object 'QC'.
DBCC results for 'MODULENAME'.
There are 239 rows in 4 pages for object 'MODULENAME'.
DBCC results for 'TNT_MAP'.
There are 33 rows in 1 pages for object 'TNT_MAP'.
DBCC results for 'CALLREC'.
There are 0 rows in 0 pages for object 'CALLREC'.
DBCC results for 'QCDSCRP'.
There are 0 rows in 0 pages for object 'QCDSCRP'.
DBCC results for 'STKADJMODE'.
There are 16 rows in 1 pages for object 'STKADJMODE'.
DBCC results for 'REGISTER'.
There are 1 rows in 1 pages for object 'REGISTER'.
DBCC results for 'AUXUNIT'.
There are 10 rows in 1 pages for object 'AUXUNIT'.
DBCC results for 'TRADERTMPBAL'.
There are 0 rows in 0 pages for object 'TRADERTMPBAL'.
DBCC results for 'INVQTY'.
There are 0 rows in 0 pages for object 'INVQTY'.
DBCC results for 'APPREPAIDMISC'.
There are 0 rows in 0 pages for object 'APPREPAIDMISC'.
DBCC results for 'DEBTOR_VENDOR'.
There are 86342 rows in 3846 pages for object 'DEBTOR_VENDOR'.
DBCC results for 'REMARKS'.
There are 3 rows in 1 pages for object 'REMARKS'.
DBCC results for 'STKADLQTY'.
There are 70617 rows in 720 pages for object 'STKADLQTY'.
DBCC results for 'PS'.
There are 0 rows in 0 pages for object 'PS'.
DBCC results for 'COSTSHEETSTEP'.
There are 0 rows in 0 pages for object 'COSTSHEETSTEP'.
DBCC results for 'CER'.
There are 0 rows in 0 pages for object 'CER'.
DBCC results for 'PASCALSCRIPT'.
There are 9 rows in 1 pages for object 'PASCALSCRIPT'.
DBCC results for 'REPORT'.
There are 1166 rows in 31 pages for object 'REPORT'.
DBCC results for 'BANK'.
There are 0 rows in 0 pages for object 'BANK'.
DBCC results for 'MRP2_TMPPO'.
There are 0 rows in 0 pages for object 'MRP2_TMPPO'.
DBCC results for 'MODULENAME_SYS'.
There are 228 rows in 2 pages for object 'MODULENAME_SYS'.
DBCC results for 'UPGRADEINFO'.
There are 8 rows in 1 pages for object 'UPGRADEINFO'.
DBCC results for 'PREPAREPOH'.
There are 1 rows in 1 pages for object 'PREPAREPOH'.
DBCC results for 'PASCALSCRIPT_BAK'.
There are 154 rows in 3 pages for object 'PASCALSCRIPT_BAK'.
DBCC results for 'APSETINV'.
There are 34479 rows in 305 pages for object 'APSETINV'.
DBCC results for 'IIR'.
There are 0 rows in 0 pages for object 'IIR'.
DBCC results for 'UPGRADETAILOR'.
There are 0 rows in 0 pages for object 'UPGRADETAILOR'.
DBCC results for 'PRODSTKTMP'.
There are 0 rows in 0 pages for object 'PRODSTKTMP'.
DBCC results for 'CRP'.
There are 0 rows in 0 pages for object 'CRP'.
DBCC results for 'BARCODE_COLOR'.
There are 0 rows in 0 pages for object 'BARCODE_COLOR'.
DBCC results for 'STKADQTY'.
There are 0 rows in 0 pages for object 'STKADQTY'.
DBCC results for 'IIRDSCRP'.
There are 0 rows in 0 pages for object 'IIRDSCRP'.
DBCC results for 'PASCALSCRIPT_HELP'.
There are 326 rows in 4 pages for object 'PASCALSCRIPT_HELP'.
DBCC results for 'EMPLOYEE'.
There are 8 rows in 1 pages for object 'EMPLOYEE'.
DBCC results for 'a123'.
There are 8492 rows in 46 pages for object 'a123'.
DBCC results for 'MODULETABLE'.
There are 84 rows in 1 pages for object 'MODULETABLE'.
DBCC results for 'PRODUCT'.
There are 20060 rows in 1753 pages for object 'PRODUCT'.
DBCC results for 'REPORTDSCRP'.
There are 6332 rows in 75 pages for object 'REPORTDSCRP'.
DBCC results for 'PASCALSCRIPT_LIB'.
There are 0 rows in 0 pages for object 'PASCALSCRIPT_LIB'.
DBCC results for 'BARCODE_MULTI'.
There are 20117 rows in 188 pages for object 'BARCODE_MULTI'.
DBCC results for 'MRP2_TMPSC'.
There are 0 rows in 0 pages for object 'MRP2_TMPSC'.
DBCC results for 'APSETMISC'.
There are 638 rows in 7 pages for object 'APSETMISC'.
DBCC results for 'PREPAREPOQTY'.
There are 0 rows in 0 pages for object 'PREPAREPOQTY'.
DBCC results for 'CHARGECODE'.
There are 3 rows in 1 pages for object 'CHARGECODE'.
DBCC results for 'PSALT'.
There are 0 rows in 0 pages for object 'PSALT'.
DBCC results for 'MOLD'.
There are 0 rows in 0 pages for object 'MOLD'.
DBCC results for 'PAYCODE'.
There are 3 rows in 1 pages for object 'PAYCODE'.
DBCC results for 'FAX_EMAIL'.
There are 0 rows in 0 pages for object 'FAX_EMAIL'.
DBCC results for 'USERAUDIT'.
There are 0 rows in 0 pages for object 'USERAUDIT'.
DBCC results for 'BARCODE_SIZE'.
There are 0 rows in 0 pages for object 'BARCODE_SIZE'.
DBCC results for 'ECNAME'.
There are 67197 rows in 1499 pages for object 'ECNAME'.
DBCC results for 'REPORTGRP'.
There are 0 rows in 0 pages for object 'REPORTGRP'.
DBCC results for 'CHARGEDEF'.
There are 0 rows in 0 pages for object 'CHARGEDEF'.
DBCC results for 'APSETTLE'.
There are 4237 rows in 126 pages for object 'APSETTLE'.
DBCC results for 'MOLDDSCRP'.
There are 0 rows in 0 pages for object 'MOLDDSCRP'.
DBCC results for 'USERDATA'.
There are 80 rows in 8 pages for object 'USERDATA'.
DBCC results for 'DECLARATION'.
There are 0 rows in 0 pages for object 'DECLARATION'.
DBCC results for 'PAYTERM'.
There are 8 rows in 1 pages for object 'PAYTERM'.
DBCC results for 'QCREASON'.
There are 0 rows in 0 pages for object 'QCREASON'.
DBCC results for 'BOM'.
There are 0 rows in 0 pages for object 'BOM'.
DBCC results for 'REPORTSELECTION'.
There are 60 rows in 1 pages for object 'REPORTSELECTION'.
DBCC results for 'PERIODEND'.
There are 2 rows in 1 pages for object 'PERIODEND'.
DBCC results for 'IIRQTY'.
There are 0 rows in 0 pages for object 'IIRQTY'.
DBCC results for 'FAX_EMAIL_RECIPIENTS'.
There are 0 rows in 0 pages for object 'FAX_EMAIL_RECIPIENTS'.
DBCC results for 'PSBOM'.
There are 0 rows in 0 pages for object 'PSBOM'.
DBCC results for 'DECLARATIONDSCRP'.
There are 0 rows in 0 pages for object 'DECLARATIONDSCRP'.
DBCC results for 'CRP1'.
There are 0 rows in 0 pages for object 'CRP1'.
DBCC results for 'COL_INF'.
There are 922 rows in 5 pages for object 'COL_INF'.
DBCC results for 'REPORTSETTINGS'.
There are 164 rows in 1 pages for object 'REPORTSETTINGS'.
DBCC results for 'PHRASE'.
There are 15 rows in 1 pages for object 'PHRASE'.
DBCC results for 'ROUTING'.
There are 0 rows in 0 pages for object 'ROUTING'.
DBCC results for 'FORM_A'.
There are 0 rows in 0 pages for object 'FORM_A'.
DBCC results for 'MOLDMISC'.
There are 0 rows in 0 pages for object 'MOLDMISC'.
DBCC results for 'MRP3'.
There are 0 rows in 0 pages for object 'MRP3'.
DBCC results for 'PSDSCRP'.
There are 0 rows in 0 pages for object 'PSDSCRP'.
DBCC results for 'IMEXPORTAUDIT'.
There are 0 rows in 0 pages for object 'IMEXPORTAUDIT'.
DBCC results for 'PICKLIST'.
There are 0 rows in 0 pages for object 'PICKLIST'.
DBCC results for 'FORM_ADSCRP'.
There are 0 rows in 0 pages for object 'FORM_ADSCRP'.
DBCC results for 'BOMCOST'.
There are 0 rows in 0 pages for object 'BOMCOST'.
DBCC results for 'APTABLE'.
There are 2 rows in 1 pages for object 'APTABLE'.
DBCC results for 'ROUTINGSTEP'.
There are 0 rows in 0 pages for object 'ROUTINGSTEP'.
DBCC results for 'DEPT'.
There are 0 rows in 0 pages for object 'DEPT'.
DBCC results for 'ECNAME_BAK'.
There are 17209 rows in 268 pages for object 'ECNAME_BAK'.
DBCC results for 'INVADVPAY'.
There are 0 rows in 0 pages for object 'INVADVPAY'.
DBCC results for 'COLOR'.
There are 59 rows in 1 pages for object 'COLOR'.
DBCC results for 'MOLDREPAIR'.
There are 0 rows in 0 pages for object 'MOLDREPAIR'.
DBCC results for 'FORM_CHANGED'.
There are 65 rows in 1 pages for object 'FORM_CHANGED'.
DBCC results for 'STKTABLE'.
There are 4 rows in 1 pages for object 'STKTABLE'.
DBCC results for 'COMPANY'.
There are 7 rows in 1 pages for object 'COMPANY'.
DBCC results for 'PO'.
There are 65236 rows in 2752 pages for object 'PO'.
DBCC results for 'ARADVPAY'.
There are 0 rows in 0 pages for object 'ARADVPAY'.
DBCC results for 'SCHEDULE'.
There are 0 rows in 0 pages for object 'SCHEDULE'.
DBCC results for 'QUERY_KEEP'.
There are 0 rows in 0 pages for object 'QUERY_KEEP'.
DBCC results for 'BOMECN'.
There are 0 rows in 0 pages for object 'BOMECN'.
DBCC results for 'DEPTMISC'.
There are 0 rows in 0 pages for object 'DEPTMISC'.
DBCC results for 'CRP2'.
There are 0 rows in 0 pages for object 'CRP2'.
DBCC results for 'MONTHS'.
There are 12 rows in 1 pages for object 'MONTHS'.
DBCC results for 'STOCKBAL'.
There are 2068656 rows in 33017 pages for object 'STOCKBAL'.
DBCC results for 'PROD_ACCOST'.
There are 0 rows in 0 pages for object 'PROD_ACCOST'.
DBCC results for 'COMPROFILE'.
There are 1 rows in 1 pages for object 'COMPROFILE'.
DBCC results for 'FORM_COMPONENTS'.
There are 0 rows in 0 pages for object 'FORM_COMPONENTS'.
DBCC results for 'BOMINFO'.
There are 0 rows in 0 pages for object 'BOMINFO'.
DBCC results for 'QUOCATMAP'.
There are 0 rows in 0 pages for object 'QUOCATMAP'.
DBCC results for 'MRP'.
There are 0 rows in 0 pages for object 'MRP'.
DBCC results for 'SCHEDULE2'.
There are 0 rows in 0 pages for object 'SCHEDULE2'.
DBCC results for 'PRODBOM'.
There are 0 rows in 0 pages for object 'PRODBOM'.
DBCC results for 'QUOCOST'.
There are 0 rows in 0 pages for object 'QUOCOST'.
DBCC results for 'DISC_PACKAGE'.
There are 0 rows in 0 pages for object 'DISC_PACKAGE'.
DBCC results for 'SCHEDULE2DSCRP'.
There are 0 rows in 0 pages for object 'SCHEDULE2DSCRP'.
DBCC results for 'FORMULA'.
There are 1 rows in 1 pages for object 'FORMULA'.
DBCC results for 'USERRIGHTS'.
There are 42009 rows in 256 pages for object 'USERRIGHTS'.
DBCC results for 'ARADVPAYMISC'.
There are 0 rows in 0 pages for object 'ARADVPAYMISC'.
DBCC results for 'SCHEDULEDSCRP'.
There are 0 rows in 0 pages for object 'SCHEDULEDSCRP'.
DBCC results for 'GRN'.
There are 49820 rows in 2187 pages for object 'GRN'.
DBCC results for 'INVTMPCOST'.
There are 0 rows in 0 pages for object 'INVTMPCOST'.
DBCC results for 'ECNAMECP'.
There are 460 rows in 23 pages for object 'ECNAMECP'.
DBCC results for 'ACBAL'.
There are 14873 rows in 121 pages for object 'ACBAL'.
DBCC results for 'MRP3_TMPPO'.
There are 0 rows in 0 pages for object 'MRP3_TMPPO'.
DBCC results for 'VENDOR_BAL'.
There are 0 rows in 0 pages for object 'VENDOR_BAL'.
DBCC results for 'DISC_TYPE'.
There are 0 rows in 0 pages for object 'DISC_TYPE'.
DBCC results for 'INVTMPMARKS'.
There are 0 rows in 0 pages for object 'INVTMPMARKS'.
DBCC results for 'PSLQTY'.
There are 0 rows in 0 pages for object 'PSLQTY'.
DBCC results for 'CRP3'.
There are 0 rows in 0 pages for object 'CRP3'.
DBCC results for 'AREA'.
There are 23 rows in 1 pages for object 'AREA'.
DBCC results for 'PODSCRP'.
There are 1581564 rows in 38749 pages for object 'PODSCRP'.
DBCC results for 'STOCKBAL_LOT'.
There are 447825 rows in 3763 pages for object 'STOCKBAL_LOT'.
DBCC results for 'ARSETINV'.
There are 102 rows in 1 pages for object 'ARSETINV'.
DBCC results for 'DN'.
There are 153217 rows in 3647 pages for object 'DN'.
DBCC results for 'PRODUCT_COLOR'.
There are 0 rows in 0 pages for object 'PRODUCT_COLOR'.
DBCC results for 'SERIALNO'.
There are 0 rows in 0 pages for object 'SERIALNO'.
DBCC results for 'MRP3_TMPSC'.
There are 0 rows in 0 pages for object 'MRP3_TMPSC'.
DBCC results for 'PSMISC'.
There are 0 rows in 0 pages for object 'PSMISC'.
DBCC results for 'PRODUCT_LOT'.
There are 17998 rows in 145 pages for object 'PRODUCT_LOT'.
DBCC results for 'ACBAL_MC'.
There are 0 rows in 0 pages for object 'ACBAL_MC'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'SERIALNO_STK'.
There are 0 rows in 0 pages for object 'SERIALNO_STK'.
DBCC results for 'ARSETMISC'.
There are 0 rows in 0 pages for object 'ARSETMISC'.
DBCC results for 'DNDSCRP'.
There are 543836 rows in 11930 pages for object 'DNDSCRP'.
CHECKDB found 0 allocation errors and 25 consistency errors in database 'EASTOP'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (EASTOP ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

My question is how can i backup and fix this database error safely.The hard disk singnal led is normal.
"One or more logical drives contain a bad stripe: controller 1" this even record is found in the serverRaid Agent.
Up to now the Sql server is running normally. The worst thing is we don't have the latest backup of this database.
Anybody Help!!!!Thanks a lot.

edit: moved to Data Corruption Forum

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-21 : 07:23:14

Firstly, you have hardware problems. Get that drive fixed before you do anything else. You've got bad disk in the raid array. Fixing that is priority 1, get your server admin to drop everything and fix that raid array

You cannot repair this damage safely. Because you have no backup (whey the hell not) the only way to repair this is to discard all the damaged portions of the database. Now, from what I can see, you have been exceedingly lucky and all the damage is in the nonclustered indexes. Hence you may actually get away with no data loss.

Once you have the disk fixed, you need some downtime to fix the DB. I don't know how much.
Take the database into single user mode and run checkDB with the repair_allow_data_loss option. It may lose data, but there's no other way. You must wait for it to finish, no matter how long it takes.
Once the repair is complete, run the following and post the full output.


DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2010-01-21 : 08:00:57

Take a cope of the MDF / LDF before you start attempting the repair - in case you want to have a second attempt :)

If you have a viable FULL backup and all subsequent TLOG backups you may be able to take a final TLOG backup (once the file is accessible again) and then restore from the FULL and all subsequent TLog backups (including the final one you make). If CHECKDB shows no errors on that you are good to go.

Restore to a NEW database name, so as not to interfere with the other one that you may still need to rescue - or dot he restore on a different machine.

Then #1 fix the reason why you didn't have a backup this time around.

jasontsang
Starting Member

5 Posts

Posted - 2010-01-21 : 08:14:37

quote:
Originally posted by GilaMonster

Firstly, you have hardware problems. Get that drive fixed before you do anything else. You've got bad disk in the raid array. Fixing that is priority 1, get your server admin to drop everything and fix that raid array

You cannot repair this damage safely. Because you have no backup (whey the hell not) the only way to repair this is to discard all the damaged portions of the database. Now, from what I can see, you have been exceedingly lucky and all the damage is in the nonclustered indexes. Hence you may actually get away with no data loss.

Once you have the disk fixed, you need some downtime to fix the DB. I don't know how much.
Take the database into single user mode and run checkDB with the repair_allow_data_loss option. It may lose data, but there's no other way. You must wait for it to finish, no matter how long it takes.
Once the repair is complete, run the following and post the full output.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

--
Gail Shaw
SQL Server MVP

I am much beholden to you for your help.
Firstly,I can copy or backup all database besides eastop database(error database) in the same drive(D:).The error database'name is Eastop.It's 15GB.
Secondly,i am not sure that the hard disk is corrupted because of the LED in the system seems to be normal(all green).At the same time,how can i find out which hard disk is corrupted.
Finally,you mean i replaced the bad hard disk so that i can backup the eastop database?? I think it's more important to backup eastop first.Fix the consistency error will be the next step.
Can i use this menthod as this link in our case:
http://www.sqlskills.com/BLOGS/PAUL/post/Example-20002005-corrupt-databases-and-some-more-info-on-backup-restore-page-checksums-and-IO-errors.aspx
Waiting ......any reply

Kristen
Test

22859 Posts

Posted - 2010-01-21 : 08:28:29

In a three-drive RAID if you replace a fault disk it should be reconstructed from the remaining two good disks. Hence you may get a completely clean copy.

If you have physical damage to your disk and the RAID has not detected the fact that would worry me!

jasontsang
Starting Member

5 Posts

Posted - 2010-01-21 : 08:28:56

Specifically,i am going to excute the command:
BACKUP DATABASE eastop TO DISK='F:\EASTOP.bck'
WITH CHECKSUM, CONTINUE_AFTER_ERROR

Is it worthy to do this?I have no idea.But as he said "Even a backup that contains a corrupt database is better than no backup at all"

agree?

jasontsang
Starting Member

5 Posts

Posted - 2010-01-21 : 08:40:31

quote:
Originally posted by Kristen

In a three-drive RAID if you replace a fault disk it should be reconstructed from the remaining two good disks. Hence you may get a completely clean copy.

If you have physical damage to your disk and the RAID has not detected the fact that would worry me!

I quite agree with you,in fact you took the words out of my mouth.:)
It's most likely that there is bad stripe in 15GB of volume.But how can i find out which hard disk is fault.The raidcard management agent log is no error

Kristen
Test

22859 Posts

Posted - 2010-01-21 : 09:23:34

Sorry, I'm not a hardware person, so no idea how to know which disk is faulty :(

Yes, definitely make a backup if you can.

If your Recovery model is FULL then also make a transaction log backup.

And if you have an old Full Backup and all Tlog backups since then, then that may be the best way to reconstruct the backup.

But I think you are going to find that you get non-recoverable errors from the Disk I/O system when you attempt to make the backup (unless you can fix the disk system first)

jasontsang
Starting Member

5 Posts

Posted - 2010-01-22 : 20:21:08

A bad stripe means that some portion of the data is lost. It may be that no data resides where the bad stripe is.
The only way to rid yourself of a bad stripe is to backup the data, delete the logical drive that contains the stripe and then recreate the logical drive.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources