0

What are the considerations that would determine which High Availability and Disaster Recovery method would be suitable for my MSSQL express server? These are some of the considerations I found on the internet

RTO (Recovery Time Objective)
RPO (Recovery Point Objective)
Criticality of Database Systems

https://www.sqlshack.com/useful-considerations-for-sql-server-disaster-recovery/

https://downloads.brentozar.com/Worksheet%20-%20High%20Availability%20and%20Disaster%20Recovery%20Planning.pdf

Above solutions look complicated for a SMB.

What would be an ideal scalable HA & DR solution for a small scale business with Maximum of approximately 10 databases and if each database is around 10GB.

Any suggestions?

2
  • log shipping dba.stackexchange.com/questions/191975/…
    – Sergey
    May 12 at 19:49
  • How much data is acceptable for loss in terms of time i.e. up to 5 minutes, 1 hour, 1 day, etc of data loss (RPO)? How long can the business tolerate being down until the database is back online (RTO)?
    – J.D.
    May 12 at 20:20

1 Answer 1

3

Only you can specify the RTO and RPO that are required. But a simple approach is to take offsite backups to Azure, and have a tested process to install SQL Server on a new server, and restore all the backups in case of a disaster.

Another simple approach is to run SQL Server on a VM and have the hypervisor handle HA and DR for SQL Server along with all your other VM workloads.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.