| Author |
Topic |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2008-10-15 : 08:46:35
|
Hi,
I restored one of database 4 days back.WHen I restored ,I ran DBCC and it didn't show any error.Today morning I noticed some error regarding page corruption.I ran DBCC and erro popup.
What could be reason of DB corruption?
Please advice.
Thanks,
-
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-15 : 08:49:02
|
A butterfly flapped it wings? 
No, seriously, we can't tell anything before seeing the actual error message from DBCC command.
E 12°55'05.63"
N 56°04'39.26" |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-10-15 : 09:00:50
|
Most likely its a problem with your I/O subsystem.
See [url]http://www.sqlskills.com/blogs/paul/post/Search-Engine-QA-26-Myths-around-causing-corruption.aspx[/url]
Paul Randal
SQL Server MVP, Managing Director, SQLskills.com |
|
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2008-10-15 : 11:10:41
|
thanks Paul,
The message I'm getting
Error: 823, Severity: 24, State: 2
I/O error (bad page ID) detected during read at offset 0x0000013714a000 in file 'E:\Program Files\MSSQL\Data\MSSQL\Data\IMXwf_data.mdf'.
|
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-10-15 : 12:03:55
|
Yup - that would be your I/O subsystem.
You need to restore from your backups onto another I/O subsystem, then run diagnostics to pinpoint the issue on your original I/O subsystem.
Thanks
Paul Randal
SQL Server MVP, Managing Director, SQLskills.com |
|
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2008-10-15 : 13:12:55
|
Thanks Paul,
Is there ay tools do you suggest to check IO Subsystem ?
Thanks,
|
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-10-15 : 13:45:08
|
Use the diagnostics that come with your I/O subsystem, plus SQLIOsim. see [url]http://www.sqlskills.com/blogs/paul/post/How-to-tell-if-the-IO-subsystem-is-causing-corruptions.aspx[/url]
Paul Randal
SQL Server MVP, Managing Director, SQLskills.com |
|
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2008-10-15 : 13:59:39
|
Thanks Paul,
Is there ay tools do you suggest to check IO Subsystem ?
Thanks,
|
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-10-17 : 10:41:10
|
See Paul's article at the link provided in his response. Some good information there.
Terry |
|
|
|
|
DB CORRUPTION AGAIN