I'm looking for some HADR solutions for our organization. I know we should have Enterprise edition to have the full fledged features but what we have is Standard Edition of SQL Server. I'm new to this organisation and in my previous endeavours I have set up HADR solutions only in Enterprise edition.
While I researched I found we can have Basic AG with Standard edition but I cant have more than one DB in the AG which makes the HA plan disastrous for our applications. Transaction Replication is not allowed in standard edition.
Is there any simple HA Plan any of you have configured with standard edition? I'm looking for the best options I'm left with before proposing Enterprise edition. Please advise.