• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

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...
0
ruemichael
Asked:
ruemichael
  • 4
  • 4
  • 2
1 Solution
 
QlemoC++ DeveloperCommented:
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.

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
0
 
ruemichaelAuthor Commented:
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?  
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
QlemoC++ DeveloperCommented:
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;

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If DBCC CHECKDB returns error you can fix them by using:
 - DBCC CHECKDB  (database_name, REPAIR_REBUILD) or
 - DBCC CHECKDB  (database_name, REPAIR_ALLOW_DATA_LOSS)

The difference between those is that REPAIR_ALLOW_DATA_LOSS will make you lose some data (only inconsistency ones). Use this option only if REPAIR_REBUILD can't fix errors.

Good luck
0
 
ruemichaelAuthor Commented:
is this from the run line or from an sql query analyzer?
0
 
QlemoC++ DeveloperCommented:
Query Analyzer
0
 
ruemichaelAuthor Commented:
Still working on this
0
 
QlemoC++ DeveloperCommented:
Still?
0
 
ruemichaelAuthor Commented:
Thank you for your support. that worked.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now