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 |
|
JohnDeere
Posting Yak Master
191 Posts |
 Posted - 2002-12-11 : 15:33:36
|
| Does anyone have an experience with intermittent or phantom 823 errors.The error DESCRIPTION: Error: 823, Severity: 24, State: 2I/O error (torn page) detected during read at offset 0x00000033ea8000 in file 'H:\Program Files\Microsoft SQL Server\MSSQL$TRANSDB\Data\Data_Sync_Data.mdf'.started happening at about 12:12 and continued until 12:36 then stopped. I was able to identify the query that was causing it.select count(*) from data_sync.dbo.sync_data where table_name = 'trans_5' and success_flag = 'F' and identify = 'O'I ran dbcc checkdb and it showed no errors. I re ran the problem query and it no longer causes the error and no other errors have been logged.BOL recommends restoring, so we may try that.Lance Harra |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-12-12 : 02:16:17
|
| Hi Lance!Sorry, I don't have a solution for you, but I'm dropping in here the link to the other (corrected) forum where you posted this so people can keep all their answers in one thread.Please post answers at:[url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=22343[/url]------------------------------------------------------The more you know, the more you know you don't know. |
 |
|
|
|
|
|
SQL ERROR 823