HELP! SQL guru is out of town!!!

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! SQL guru is out of town!!!

Author

Topic

Dave Gill
Starting Member

1 Post

Posted - 2006-05-12 : 15:21:25

I got the following error on my database when I ran DBCC CHECKDB

Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'PhoneCall' (ID 254623950). Missing or invalid key in index 'PhoneCall0' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:98383:16) identified by (RID = (1:98383:16) ) has index values (PhoneCallID = 46361).

This error is on a couple of different indexii?? What do I do? Any help will be appreciated. Thank you

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-05-12 : 15:25:23

Run DBCC CHECKDB(YourDBName) in Query Analyzer. Post the entire result set here. MS engineers check this forum and should be able to help you.

Tara Kizer
aka tduggan

Kristen
Test

22859 Posts

Posted - 2006-05-13 : 03:10:27

"Post the entire result set here"

In that case might be better if Dave Gill runs:

DBCC CHECKDB ('MyDatabase') WITH ALL_ERRORMSGS, NO_INFOMSGS

Kristen

nr
SQLTeam MVY

12543 Posts

Posted - 2006-05-13 : 06:07:21

Try rebuilding the indexes that have problems.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-05-15 : 12:39:17

quote:
Originally posted by nr

Try rebuilding the indexes that have problems.

That's just a band-aid. You need to figure out what happened to cause the problem.

Which version of SQL Server are you using (including SP level)? Do you have that CHECKDB output?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

nr
SQLTeam MVY

12543 Posts

Posted - 2006-05-15 : 12:49:38

If you want to know what caused it I would have a look in the windows event log first - for disk errors in particular.
Or did the system crash at some point?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources