DB CORRUPTION AGAIN - SQL Server Forums

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.

All Forums

General SQL Server Forums

Data Corruption Issues

DB CORRUPTION AGAIN

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources