Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corruption of data
Message
From
22/11/2011 12:49:05
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Corruption of data
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01529561
Message ID:
01529561
Views:
154
I have never this one:

The operating system returned error 23(Data error (cyclic redundancy check).) to SQL Server during a read at offset 0x0000000c4f0000 in file 'D:\SqlData\MyTable\MyTable.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

We have a corruption somewhere.

All the errors point to the same table at the write time. We have removed the index and recreated it. This was not a factor. As this is a log table, we are trying to clean it up, remove the index, recreate the index and see if that resolves the issue. We have a backup of it. At this point, we can verify if all is OK with data when attempting to do a backup. At this point, the backup cannot be done as it reports something about the MDF. So, while we wait for those procedures to take place, I was wondering if someone already had this situation.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform