2

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.

  • Mirroring is still at the individual database level so you won't want that. The only other thing for HA is an FCI, which does work in standard edition. Log shipping, et al, are not HA but rather DR solutions. – Sean Gallardy Apr 4 '17 at 16:01
  • @SeanGallardy you can do some scripting to get LS/Mirrored databases to fail over in groups, but yeah... – Erik Darling Apr 4 '17 at 16:04
  • Thank you @SeanGallardy. I think FCI is the pretty decent option I have! – Ramya Apr 4 '17 at 16:59
  • @sp_BlitzErik Thank you for your comment :) Big follower of Brent Ozar Unlimited Blogs :) – Ramya Apr 4 '17 at 17:01
  • @Ramya glad you like them! Thanks for reading! – Erik Darling Apr 4 '17 at 17:02
4

Log Shipping for DR. Not so much HA as no automatic failover, but still better than nothing. Use Windows cluster for HA, and Log ship them to somewhere else.

transactional replication IS allowed in standard: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-supported-features-for-sql-server-2016#a-namereplicationa-replication

But is not really an HADR solution

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.