ruemichael
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...
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...
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
Identify the database and run DBCC CHECKDB on it. It should report you for the errors in your DB.
Good luck
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?
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;
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
is this from the run line or from an sql query analyzer?
Query Analyzer
ASKER
Still working on this
Still?
ASKER
Thank you for your support. that worked.
select @object_name(2025058250)
and at least those indexes should be re-created immediately.