Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corruption of data
Message
 
 
To
22/11/2011 12:49:05
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01529561
Message ID:
01529649
Views:
63
This message has been marked as a message which has helped to the initial question of the thread.
What DBCC CHECKDB reported? Are you running it daily to catch corruption immediately?

>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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform