|
|
||||||
|
#1
04-30-05, 04:57 PM
|
|
|
|
|
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 0x0000111c264000 in file 'D:\MSSQL\MSSQL\Data\production_Data.mdf'. COMMENT: (None) JOB RUN: (None) What do I need to do here? TIA, ChrisR |
|
|
|
#2
04-30-05, 05:35 PM
|
|
|
|
|
Hi
Look like corruption. Run DBCC CHECKDB on the database and get last nights backup out, you might need to restore it. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "ChrisR" <noemail> wrote in message news:2680 [..] |
|
#3
04-30-05, 07:00 PM
|
|
|
|
|
Here's some additional info about those situations:
http://www.karaszi.com/SQLServer/inf...suspect_db.asp |
|
|
| Similar Threads | |
| Torn Page 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... |
|
| Torn Page Detection? What is the most dangerous side effect if the "Torn Page Detection" property of a database turned off and the system exposed to a power failure? |
|
| Torn Page Detection Does anyone have any thoughts on using Torn Page Detection or not? I see where Microsoft, in there documentation, tells you to use it, then they say don't use it. Not... |
|
| need help to repair torn page SQL 2000 advanced server got torn page message. I tried to use DBCC CHECKDB('DBNAME',REPAIR_REBUILD) to do the repaire. 1. is this the correct way to do the repair? 2. I... |
|
| 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 06:11 AM. | Privacy Policy
|
do I have a torn page?