Sage 100c Premium (SQL) Disaster Reocvery

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.

Parents
  • FormerMember
    FormerMember

    Disaster recovery assumes you have tried the process and verified it works.

    I had a false server issue and I put my disaster recovery in to action. My sleeping instance told me I couldn't update the subscription as the AMI was no longer available in the Marketplace. Trying to restore the nightly backups failed with bad signatures. It seems the software I was using to do the auto backups was uploading garbage to S3.

    Thankfully the issue with my server was my IP was jailed by the hosting software preventing access. Once I made the IP trusted everything returned to normal.

    I spent the rest of the day certifying my disaster recovery worked and not just assuming it would.

Reply
  • FormerMember
    FormerMember

    Disaster recovery assumes you have tried the process and verified it works.

    I had a false server issue and I put my disaster recovery in to action. My sleeping instance told me I couldn't update the subscription as the AMI was no longer available in the Marketplace. Trying to restore the nightly backups failed with bad signatures. It seems the software I was using to do the auto backups was uploading garbage to S3.

    Thankfully the issue with my server was my IP was jailed by the hosting software preventing access. Once I made the IP trusted everything returned to normal.

    I spent the rest of the day certifying my disaster recovery worked and not just assuming it would.

Children