>Except that this method require more work to restore a damaged table, because the backup table doesn't have all the structure of the original (field name lenght, default values, triggers, etc.)

---

>If you don't want to get your users out of the system, a SELECT * FROM mytable INTO myBakTable is a simple choice.

Not everyone uses all the functionality of the DBC - this will work in the case of an extreme emergency. The absolute best way to back up is to use a tape drive with appropriate software and ensure the users are out of the data. I'm just giving options to the question asked.


Wayne