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 |
|
ahenry
Starting Member
4 Posts |
 Posted - 2008-03-20 : 14:26:43
|
| Server Error Message:Server: Msg 8928, Level 16, State 1, Line 1Object ID 1010818663, index ID 0: Page (1:305381) could not be processed. See other errors for details.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 1010818663, index ID 0, page (1:305381), row 34. Test (offsetNull >= BASEOFFSET) failed. Values are 0 and 4. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 00:50:28
|
| How did you get this error? Any other error in windows event logs? |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-03-21 : 11:57:17
|
| Sorry, should have added this before posting. It doesn't APPEAR to be hardware related. Almost sounds like a corrupt index that should be rebuilt.Terry |
|
|
|
ahenry
Starting Member
4 Posts |
Posted - 2008-03-24 : 08:04:03
|
| There wasn't any errors in the event log during that current week. This is a NetApp drive and we had problem during the birth of the installable of SQL Server 2000 (sp4) on the new hardware in Jan 2008. I attempted to drop and recreate the indexes but the drop was successful and not the creation. The DBCC checkdb showed 2 tables were the problem. I performed reads on the table failed once it reached the bad row. I performed DBCC CheckDB with ALLOW_DATA_LOSS and it put the database in a stable state. Reran DBCC which was fine and the database was healthy and accessible. Given the DBCC return message, I wanted to know for sure that the returned error message is truly hardware and not an assumption. Microsoft website points to hardware. Finally, Windows Administrators state no error for the drive was reported within the event log. |
|
|
|
ahenry
Starting Member
4 Posts |
Posted - 2008-03-24 : 08:07:33
|
| tosscrosby,I have performed all the recommended DBCC commands with options from Microsoft website and others, but I was able to get clean DBCC until I performed the "ALLOW_DATA_LOSS". |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 23:25:31
|
| Sounds NetApp related to me. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-03-27 : 20:12:52
|
| There isn't enough info in the the thread to tell whether it's HW related or not. It could be something in the IO subsystem that flipped the single bit that turns a zero into a 4, but there's no definitive proof.ThanksPaul RandalManaging Director, SQLskills.com |
|
|
|
|
|
|
|
|
Please confirm Hardware error