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.
| Author |
Topic |
|
sasan.kh
Starting Member
23 Posts |
 Posted - 2009-02-02 : 02:47:08
|
| Hi allI have a sql server 2000(without any servis packs installed) database with some tables containing near 2-3 million records. recently consistency errors are seen frequently specially on these high record tables... How can I find the source of the problem? and I want to know if index design mistakes can do this...regardssasan |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-02 : 09:10:03
|
Please post the results of below in Database Corruption Topic:DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS |
 |
|
|
sasan.kh
Starting Member
23 Posts |
Posted - 2009-02-03 : 06:52:01
|
| Thanx sodeepthe result is:Server: Msg 8960, Level 16, State 1, Line 1Table error: Page (1:68556), slot 26, column 2 is not a valid complex column.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1435079. The text, ntext, or image node at page (1:97232), slot 85, text ID 55999922176 is not referenced.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 269244014, Index ID 0. Keys out of order on page (1:148), slots 266 and 267.CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.CHECKDB found 0 allocation errors and 1 consistency errors in table 'spJavab_Az' (object ID 1435079).CHECKDB found 0 allocation errors and 1 consistency errors in table 'ICDCodes' (object ID 269244014).CHECKDB found 0 allocation errors and 3 consistency errors in database 'dbSina'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (dbSina ). |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-03 : 09:17:04
|
quote:
Originally posted by sasan.kh
Thanx sodeepthe result is:Server: Msg 8960, Level 16, State 1, Line 1Table error: Page (1:68556), slot 26, column 2 is not a valid complex column.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1435079. The text, ntext, or image node at page (1:97232), slot 85, text ID 55999922176 is not referenced.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 269244014, Index ID 0. Keys out of order on page (1:148), slots 266 and 267.CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.CHECKDB found 0 allocation errors and 1 consistency errors in table 'spJavab_Az' (object ID 1435079).CHECKDB found 0 allocation errors and 1 consistency errors in table 'ICDCodes' (object ID 269244014).CHECKDB found 0 allocation errors and 3 consistency errors in database 'dbSina'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (dbSina ).
Post it in Database Corruption page so corruption experts like Paul Randal can Guide you to right way. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-02-03 : 10:13:38
|
| And why no service packs? IMO you should be patched to sp4 as you are currently exposed to some potential security risks.Terry-- Procrastinate now! |
|
|
|
sasan.kh
Starting Member
23 Posts |
Posted - 2009-02-12 : 08:03:06
|
| I installed SP4 and it seems that the problem is gone.... Thanx all |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-12 : 08:11:10
|
quote:
Originally posted by sasan.kh
I installed SP4 and it seems that the problem is gone.... Thanx all
GOOD. |
|
|
|
|
|
|
|
|
frequent Consistency errors