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 |
|
espino316
Starting Member
3 Posts |
 Posted - 2007-01-22 : 12:13:22
|
| Hi, I hope somebody can help me.I don't really have the problem anymore, but I'd like to know exactly what causes inconsistency in a table, I'm using SQL SERVER 2000 SP4.I solved the problem of iconsistency with DBCC repair_allow_data_loss, in very short time, luckly, no need to restore, no significant data loss occurr, the very same day the production database work again.The thing is that I search the origin of the problem but find nothing. I really wold like to know what causes this kind of problem and how can I prevent them. I have look in many forums and bases of knowledge, but only steps of how to fix the problemm appear.Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-22 : 13:07:07
|
| It's usually a hadware problem.Can be a disk closing down before writing the data.SQL Server should know what has been written and what hasn't and roll back incomplete transactions on start up but sometimes it doesn't.Can just be a bug, incompatibility between subsystems, disk reporting a completion too early, bad sectors, SAN's without latest updates or wrong options set.Worked on a system where if the disks weren't powered down before being turned off (e.g. power cut or turning off the machine) they would always give you a corruption. Lot's of things - Paul Randall might be along to give a comprehensive and incomprehensible list.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
espino316
Starting Member
3 Posts |
Posted - 2007-01-22 : 15:36:47
|
| Thank you very much, nr.Fortunely, I had a trace running at that time, and I able to discover some particular behaviors, as a start for my research. Your reply was very useful. Thanks again. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-22 : 16:40:51
|
| Have a look at the windows event viewer.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-01-24 : 08:11:04
|
| Nigel's listed most of the causes - its almost always something in the IO path.Nigel - not sure what you meant by 'comprehensive and incomprehensible' ??Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
|
|
|
|
|
What causes inconsistency???