which High Availability and Disaster Recovery method would be suitable for my SQL Express server
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
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.
Only you can specify the RTO and RPO that are required. But a simple approach is to take offsite https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-ver15 , 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.