Link to home
Start Free TrialLog in
Avatar of ruemichael
ruemichaelFlag for United States of America

asked on

SQL 2000 Event ID 17052 errors 2-3 per minuet

Hello

I have been getting the following error on a SQL 2000 box with WIN2k3 SP2 for a couple of days at least. I am getting 2 -4 per minuet that eating up my event logs. I have tried to search for an answer but I have not massage Google correctly to give an answer.

Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17052
Date:            4/28/2009
Time:            12:40:03 PM
User:            N/A
Computer:      XXXXXXX
Description:
Error: 623, Severity: 20, State: 1
Could not retrieve row from page by RID because logical page (1:6100560) is not a data page. Rid pageid is (1:6100560) and row num is 0x0. Page pointer = 0x7fd66000, PageId = (1:6100560), flags = 0x0, objectid = 2025058250, indexid = 5.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 6f 02 00 00 14 00 00 00   o.......
0008: 07 00 00 00 41 00 52 00   ....A.R.
0010: 43 00 53 00 41 00 4e 00   C.S.A.N.
0018: 00 00 05 00 00 00 32 00   ......2.
0020: 30 00 30 00 38 00 00 00   0.0.8...
Avatar of Qlemo
Qlemo
Flag of Germany image

You should start a Maintenance Job for Re-Creation of all indexes very soon. The object id given should tell you which table is referenced, with

select @object_name(2025058250)

and at least those indexes should be re-created immediately.

Looks like you are having consistency error in your database.
Identify the database and run DBCC CHECKDB on it. It should report you for the errors in your DB.

Good luck
Avatar of ruemichael

ASKER

Thank you, for your resonance.
Im not familiar with this command for SQL. How do you ID the DB? How do you use it command to repair the DB?  
The syntax is
 
DBCC checkdb [('database_name'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, DBCC TABLOCK]  

Your eventlog entry does not reveal the database or its ID, so I suggest to do all DBs one after another, e.g.

dbcc checkdb 'mydb', repair;

ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
is this from the run line or from an sql query analyzer?
Query Analyzer
Still working on this
Still?
Thank you for your support. that worked.