corruption. These are unattended 24/7 systems, and we are not sure what is
going on.
I was under the impression that MSDE aka SQLServer was fairly fault
tolerant. Could someone explain some of the reasons for database
corruption?
An example of one of the errors that we have seen when this occurs is as
follows:
IO Error 23 "Data Error" Cyclic Redundancy Check Detected During Read at
Offset 0x00000c150000 in the file D:\sqslsrvdata\data\dvrevent40_data.mdf
Any useful insight on the cause of something like this would be very
helpful.
--
Ken Varn
Senior Software Engineer
Diebold Inc.
EmailID = varnk
Domain = Diebold.com
hi Ken,
Ken Varn wrote:
> We have been seeing a few of our systems using MSDE have database
> corruption. These are unattended 24/7 systems, and we are not sure
> what is going on.
SQL Server is usually as "tolerant" as your system is..
often this kind of problems is consequence of bad I/O activity, say hard
disk problem and the like...
did you check your disk(s) subsystem?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
