This may also apply to any e-commerce business such as Magento.
I have a new Magento installation, and I want to be prepared for when a client asks me about backups. I know about all (or most) backup methods, as well as the various bits that are protected by each type, but I have to do with open orders. What happens to orders placed after the most recent database backup in case of recovery? I assume that the backup copy of the database will store open orders in the system, but, obviously, I cannot take and store backups every second of the day.
So, what happens to orders made after the last backup if the database is damaged and needs to be restored? I suppose there will be at least some chance that some orders may be lost. Am I mistaken? If not, then what is standard practice for? The products my client sells are not so cheap, so typical orders are at least hundreds (euros).
source
share