Backup for Galaxy and Pylon: how to never lose your data
Invoices, customers, stock, accounts: the whole business lives in one database. A failed disk, ransomware or a wrong action can ruin it. A proper backup is the difference between a bad day and a disaster.
Where your data lives
When installed on the business's server, Galaxy and Pylon keep their data in a Microsoft SQL Server database. Copying the program folder is not enough. You need a proper database backup from SQL Server, which is taken correctly even while users are working.
With Epsilon Smart, which runs in the cloud, Epsilon looks after the database. Still, it is wise to keep periodic exports of your key data.
The 3-2-1 rule
- 3 copies of your data: the live data and two backups.
- 2 different media, for example a network drive (NAS) and the cloud.
- 1 copy off site, so a fire, theft or flood doesn't take the backup with it.
Ransomware: if the backup sits in a folder the server can see, ransomware will encrypt it too. Keep at least one copy that the server cannot delete or modify: a disconnected drive or cloud storage with deletion protection (immutable).
What a proper ERP backup needs
- Automatic, every day. A backup that depends on someone remembering to press a button will, at some point, not happen.
- Many versions. Keep copies from several days, weeks and months. You may only notice a mistake much later.
- A backup before every upgrade of the program and before year-end closing.
- An alert when it fails. The most dangerous backup is the one that stopped six months ago and nobody noticed.
- Encryption for copies that leave the office, because they contain personal data of customers and employees.
- Restore testing. At least every few months, restore a backup to a test database and check that it opens. This is the step almost everyone forgets.
Don't forget the rest
Besides the ERP database, shared files, email, server settings and licences matter too. A complete plan answers the question: if the server fails tomorrow, how many hours until we are working again?
How we help
We set up automatic backups of SQL databases and files, on site and off site, with alerts and regular restore tests. With a support contract we also check your backups. See all our IT services.
Do you know if your backup works?
We check your business's backups and recommend what is missing, across Attica.
