I'm confused about the relationship between Sage data files and the SQL database. If a server dies, or gets ransomed, my first step will obviously be to reload the application server from backup, then the SQL backups. There is potential for different backup times between the two Sage file system backups and the SQL backups. How is this differing data reconciled? And, if I can just load a SQL backup, then how come I need to use the migration tool when migrating servers?
I read through : https://support.na.sage.com/selfservice/viewContent.do?externalId=37699&sliceId=1 and : https://support.na.sage.com/selfservice/viewContent.do?externalId=20262&sliceId=1
But I'm still not clear on the procedure and how everything fits together.