Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Corupt records...How do you Automate Detection,Delete
I've had a few user's experience corupt records within several tables do to a server crash, power outage, etc.
Is there a way to detect/delete corupt records? The records read like bar code but as far as I can tell, I can't query them out (delete-sql). I found I can do an export to excel sheet, clean the table and re-import the data. The bad records don't get exported. However, this seems to take a long time. Anyone have a better method?
Thanks in Advance!
Daren Hopper
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement