Data loss is pretty much theoretical.
We do a monthly full backup and “incrementals”, i.e. backups of the files which have been changed, on all other days.
In addition to this, we perform “log-file-shipping” every 5 minutes so that the maximum amount of data that can be lost in connection with a total crash is 5 minutes of activity.
Once in the quarter we perform a ‘disaster recovery test’ and determine the outcome of this, both in relation to data integrity and in relation to the time needed for re-establishment.
Documentation of the conduction of these tests is also provided in our ISAE-rapport from Deloitte.
We are continuously working on this process, and in 2021, we will change our backup routines so that, in addition to being run as they are now, they will be re-established on a hot-standby SQL server every 5 minutes so that it contains the latest data from our backup and “log-file-shipping”.
If an accident happens, our restoration of the operating environment will take place in less than 60 minutes once the new process is implemented.