|
|
||||||
|
#1
08-10-04, 12:00 AM
|
|
|
|
|
I found this message in the SQL Server Log:
I/O error (torn page) detected during read at offset 0x000000c3878000 in file 'E:\Program Files\Microsoft SQL Server\MSSQL\Data\SillaLive.mdf'. From what I have read, I think this is a corrupted table or index. I am going to run dbcc checkdb 'dooda', REPAIR_ALLOW_DATA_LOSS ) after we close tonight. Is this going to be a probelm. Also, Any idea how the database got corrupted. We have not had a power failure or hardware problem that I know of. TIA Mike |
|
|
|
#2
08-10-04, 04:27 AM
|
|
|
|
|
Hi,
After taking a backup, Please try the DBCC with REPAIR_REBUILD option first. This will not cause you any data loss. REPAIR_ALLOW_DATA_LOSS option will cause you a data loss and will result in data consistency problm. If it is testing database you could try this. This error normally occurs due to hard ware failures. Please contact Microsoft Product Support Services (MS PSS) for investigation. Thanks Hari MCDBA "Michael Beck" <Mikeb46NoSpam> wrote in message news:a556 [..] |
|
#3
08-10-04, 04:36 AM
|
|
|
|
|
Mike,
Torn pages are mostly hardware related. You may want to check your Application and system event logs and match the detection time to events in the logs. Let your hardware vendor run diagnostics to check the health of your hardware. You may want to run DBCC checkdb without specifying a repair option. The output will be the result of what table(s) is/are affected. CheckDB will also recommend the least allowable level of REPAIR option. Thanks, TJ "Michael Beck" <Mikeb46NoSpam> wrote in message news:a556 I found this message in the SQL Server Log: I/O error (torn page) detected during read at offset 0x000000c3878000 in file 'E:\Program Files\Microsoft SQL Server\MSSQL\Data\SillaLive.mdf'. From what I have read, I think this is a corrupted table or index. I am going to run dbcc checkdb 'dooda', REPAIR_ALLOW_DATA_LOSS ) after we close tonight. Is this going to be a probelm. Also, Any idea how the database got corrupted. We have not had a power failure or hardware problem that I know of. TIA Mike |
|
|
| Similar Threads | |
| Torn Page Restore Hi All, Quick question... I've found that a database in our system has encountered a torn page error. DBCC CheckDB hasn't worked any wonders so we're going to restore from... |
|
| Torn Page Detection I have a production database that processes 600 transaction/sec. and 300 concurrent users. This is a SQL Server 2000 Enterprise Edition database in a cluster server with... |
|
| do I have a torn page? Ive been getting alerts like the following all morning: DESCRIPTION: Error: 823, Severity: 24, State: 2 I/O error (bad page ID) detected during read at offset... |
|
| Torn page reattachment I need to attach a database that was detached due to being suspect because of torn pages. Is there a way to attach the db in emergency mode? Thanks, Doug |
|
| Torn page I get a message of a torn page in a databse. Can I do anything to save the data? |
|
|
All times are GMT. The time now is 02:51 AM. | Privacy Policy
|
Torn Page