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 : 23:29:23
|
| Sorry posted this in the wrong forum the 1st time.Does anyone have an experience with intermittent or phantom 823 errors. The error DESCRIPTION: Error: 823, Severity: 24, State: 2 I/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 Lance Harra |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-12 : 12:26:48
|
| If you don't already have this flag turned on, turn it on: torn page detection. You can set this flag through EM or by executing sp_dboption in QA. |
 |
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2002-12-12 : 13:30:53
|
| Thanks torn page detection is already on.Lance Harra |
|
|
|
|
|
|
SQL Error 823