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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-15 : 08:18:37
|
| adeola writes "each time i transfer data using the dts this error comes up frequently "i/o bad page error.how can i rectify this" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-09-15 : 08:40:47
|
| Read up on and Investigate using "DBCC CHECKDB" against the database in question. You've got problems that won't go away without some correction action. |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-09-15 : 17:43:08
|
quote:
Originally posted by AskSQLTeam
adeola writes "each time i transfer data using the dts this error comes up frequently "i/o bad page error.how can i rectify this"
Can you post the actual error you get? CHECKDB will help you determine how damaged your database is but will not be able to fix the problem (which sounds like hardware, depending on which IO error you're getting). You should run hardware diagnostics on your IO sub-system and also check the Windows event logs and SQL errorlogs for evidence of disk/controller problems.Also, do you have up-to-date firmware?ThanksPaul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-16 : 00:32:19
|
Just out of curiosity.... Is there a SAN involved here?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
io page error