Help me Please Error Index - Primary Key

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

Help me Please Error Index - Primary Key

Author

Topic

ManInBlack
Starting Member

5 Posts

Posted - 2008-04-09 : 21:54:53

'PXQ_2' table
- Unable to delete index 'PK_PXQ'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x0000000102e000 in file 'D:\MSSQL2000\MSSQL\xxx.mdf'.

I can't drop Primary Key. How to fix this problem?

Hardware(HDD) no error. I test oke?

Please help me.

-= MIB =-

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-09 : 22:09:37

Looks like you've got database corruption.

Does DBCC CHECKDB return errors?

Have you tried recreating the primary key in case the index is corrupted?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

ManInBlack
Starting Member

5 Posts

Posted - 2008-04-09 : 22:20:41

Ya I test DBCC CHECKDB(xxx) show error:
------------------------------------------------------------------------------------------------------------------------
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:2071). The PageId in the page header = (0:0).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 330588366, index ID 0: Page (1:2071) could not be processed. See other errors for details.
DBCC results for 'xxx'.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 436 rows in 14 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 321 rows in 33 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1502 rows in 45 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 368 rows in 73 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 47 rows in 9 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 864 rows in 12 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 27 rows in 1 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 'dmTokhai'.
There are 0 rows in 87 pages for object 'dmTokhai'.
DBCC results for 'dmNhom_h'.
There are 12 rows in 1 pages for object 'dmNhom_h'.
DBCC results for 'PXQVE'.
There are 0 rows in 1 pages for object 'PXQVE'.
DBCC results for 'tmpPNQ'.
There are 0 rows in 1 pages for object 'tmpPNQ'.
DBCC results for 'tmpPNQCT'.
There are 0 rows in 1 pages for object 'tmpPNQCT'.
DBCC results for 'tmpPXQ'.
There are 3 rows in 1 pages for object 'tmpPXQ'.
DBCC results for 'dmVatTu'.
There are 1307 rows in 55 pages for object 'dmVatTu'.
DBCC results for 'tmpPXQCT'.
There are 17 rows in 1 pages for object 'tmpPXQCT'.
DBCC results for 'tmpCDDDQ'.
There are 2551 rows in 80 pages for object 'tmpCDDDQ'.
DBCC results for 'HDH'.
There are 7 rows in 1 pages for object 'HDH'.
DBCC results for 'sysIDsHandle'.
There are 2 rows in 1 pages for object 'sysIDsHandle'.
DBCC results for 'PDGCT'.
There are 135 rows in 6 pages for object 'PDGCT'.
DBCC results for 'dmCounter'.
There are 1 rows in 1 pages for object 'dmCounter'.
DBCC results for 'dtproperties'.
There are 91 rows in 2 pages for object 'dtproperties'.
DBCC results for 'PXQ_2'.
There are 3356 rows in 135 pages for object 'PXQ_2'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'PXQ_2' (object ID 330588366).
DBCC results for 'dmUsers'.
There are 120 rows in 5 pages for object 'dmUsers'.
DBCC results for 'pxq'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1293) allocated to object ID 1137543236, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1294) allocated to object ID 1137543236, index ID 0 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 1137543236, index ID 1. Index node page (1:345), slot 100 refers to child page (1:1293) and previous child (1:1291), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1137543236, index ID 1. Index node page (1:345), slot 101 refers to child page (1:1294) and previous child (1:1293), but they were not encountered.
There are 3383 rows in 135 pages for object 'pxq'.
DBCC results for 'dmVatTuNcc'.
There are 1696 rows in 34 pages for object 'dmVatTuNcc'.
DBCC results for 'dmnhomhd'.
There are 11 rows in 1 pages for object 'dmnhomhd'.
DBCC results for 'PDD'.
There are 56 rows in 2 pages for object 'PDD'.
DBCC results for 'pxqtt_2'.
There are 22 rows in 1 pages for object 'pxqtt_2'.
DBCC results for 'dmNhomNcc'.
There are 8 rows in 1 pages for object 'dmNhomNcc'.
DBCC results for 'pxqct'.
There are 14569 rows in 470 pages for object 'pxqct'.
DBCC results for 'PNQ'.
There are 270 rows in 8 pages for object 'PNQ'.
DBCC results for 'dmQuocGia'.
There are 52 rows in 1 pages for object 'dmQuocGia'.
DBCC results for 'PDDCT'.
There are 356 rows in 13 pages for object 'PDDCT'.
DBCC results for 'PDG'.
There are 10 rows in 1 pages for object 'PDG'.
DBCC results for 'HDHCT'.
There are 15 rows in 1 pages for object 'HDHCT'.
DBCC results for 'CdddQ'.
There are 3704 rows in 113 pages for object 'CdddQ'.
DBCC results for 'PNQCT'.
There are 2297 rows in 102 pages for object 'PNQCT'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'PNQCT' (object ID 1137543236).
DBCC results for 'dmKho'.
There are 1 rows in 1 pages for object 'dmKho'.
DBCC results for 'dmCuaHang'.
There are 4 rows in 1 pages for object 'dmCuaHang'.
DBCC results for 'dmgh'.
There are 4 rows in 1 pages for object 'dmgh'.
DBCC results for 'dmNoiVc'.
There are 40 rows in 1 pages for object 'dmNoiVc'.
DBCC results for 'PXQCT_2'.
There are 14399 rows in 465 pages for object 'PXQCT_2'.
DBCC results for 'dmTLuongVc'.
There are 3 rows in 1 pages for object 'dmTLuongVc'.
DBCC results for 'DmGiaVC'.
There are 120 rows in 1 pages for object 'DmGiaVC'.
DBCC results for 'dmKhuVuc'.
There are 5 rows in 1 pages for object 'dmKhuVuc'.
DBCC results for 'dmLgia'.
There are 5 rows in 1 pages for object 'dmLgia'.
DBCC results for 'PVC'.
There are 1 rows in 1 pages for object 'PVC'.
DBCC results for 'dmDichDanh'.
There are 2648 rows in 111 pages for object 'dmDichDanh'.
DBCC results for 'dmNcc'.
There are 9 rows in 1 pages for object 'dmNcc'.
DBCC results for 'PVCTT'.
There are 0 rows in 1 pages for object 'PVCTT'.
DBCC results for 'dmChungTu'.
There are 1 rows in 1 pages for object 'dmChungTu'.
DBCC results for 'Dmnt'.
There are 12 rows in 1 pages for object 'Dmnt'.
DBCC results for 'dmDong_h'.
There are 1 rows in 1 pages for object 'dmDong_h'.
DBCC results for 'dmdtck'.
There are 1 rows in 1 pages for object 'dmdtck'.
DBCC results for 'sysPublicVar'.
There are 29 rows in 1 pages for object 'sysPublicVar'.
DBCC results for 'Dmhttt'.
There are 8 rows in 1 pages for object 'Dmhttt'.
DBCC results for 'Dmtgnt'.
There are 2464 rows in 52 pages for object 'Dmtgnt'.
DBCC results for 'HDHTT'.
There are 5 rows in 1 pages for object 'HDHTT'.
DBCC results for 'PhanCa'.
There are 2 rows in 1 pages for object 'PhanCa'.
DBCC results for 'dmNganh_h'.
There are 11 rows in 1 pages for object 'dmNganh_h'.
DBCC results for 'dmGiaoDich'.
There are 23 rows in 1 pages for object 'dmGiaoDich'.
DBCC results for 'PXQTT'.
There are 3424 rows in 38 pages for object 'PXQTT'.
DBCC results for 'DMHangHK'.
There are 0 rows in 1 pages for object 'DMHangHK'.
DBCC results for 'DmQuocTich'.
There are 91 rows in 1 pages for object 'DmQuocTich'.
DBCC results for 'dmNghiepVu'.
There are 6 rows in 1 pages for object 'dmNghiepVu'.
DBCC results for 'dmHD'.
There are 10 rows in 1 pages for object 'dmHD'.
DBCC results for 'DMChuyenBay'.
There are 0 rows in 1 pages for object 'DMChuyenBay'.
CHECKDB found 0 allocation errors and 6 consistency errors in database 'xxx'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (xxx ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
------------------------------------------------------------------------------------------------------------------------
Hepl me please

-= MIB =-

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-09 : 22:53:39

Moving the thread to the data corruption forum so that Paul Randall can help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

ManInBlack
Starting Member

5 Posts

Posted - 2008-04-09 : 23:04:19

Thanks Tara Kizer

-= MIB =-

ManInBlack
Starting Member

5 Posts

Posted - 2008-04-09 : 23:12:00

Any help me Please

-= MIB =-

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-10 : 00:04:06

If you need immediate assistance, you should open a case with Microsoft.

Did you try dropping and then recreating the pk like I suggested?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

ManInBlack
Starting Member

5 Posts

Posted - 2008-04-10 : 03:34:00

I can't drop PK show

Error message:'PXQ_2' table
- Unable to delete index 'PK_PXQ'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x0000000102e000 in file 'D:\MSSQL2000\MSSQL\xxx.mdf'.

When try save one more error show:
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure

n I have canceled, n Open Design Again show Error:

The connection to SQL Server 'LOCAL' has been Broken.
The connection to SQL Server is Broken. Do you want try Reconecting to it?

Please Help me.

-= MIB =-

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources