What should a user do about corruption problems going forward?
recommendation #1 would be to make sure you have a backup strategy that assures you have multiple generations of backup, are not depending on any one type of backup media, and that your backups really are. Restoring from your last weekly backup and re-entering three or four days of transactions is probably easier than most any technique for repair described here. Finally, some users who have been here, done this, decide to start regularly using the repair tools as a prophylactic against future file corruption. There is no evidence that this is an effective strategy. Worse, there is significant anecdotal evidence that the repair tools can emit meaningless messages about problems in your data file when there are absolutely no other indications of any problem. Given how little we know about these tools and how little is documented and how little we know about what they are designed to do/fix and how rigorously they are tested and so on (why I refer to them as voodoo tools), this fixation
