Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corruption of data
Message
De
22/11/2011 12:49:05
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Corruption of data
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01529561
Message ID:
01529561
Vues:
155
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform