A common mistake made by people when setting up a Sage backup is to secure the individual files used by the Sage accounting package. Sage, like many complex data- driven systems, stores information into various linked tables and indexes.
Backing up these individual files may indeed work. But, just as likely, it may not.
The fact is when you backup individual SAGE files there is no guarantee that all the data has been committed to the database. There is no guarantee that the tables and indexes are in synch, and there is no guarantee that someone isn’t updating the database at the precise moment the backup is taking place.
In short, when you come to recover your SAGE data, you may end up restoring a corrupt database – not exactly the desired outcome. |