1.)According to brent ozar's HA and DR chart,for Failover Cluster Instance - SQL Server minimum version supported and SQL Server minimum edition required is given as 'any'. Does that mean it works with sql express? or am I misinterpreting the meaning of 'any'? According to microsoft it doesn't work for sql express.

2.)Same chart also says that sql server Replication can automatically failover. Here is what I found. How does the automatic failover happen in case of replication if it is possible?

1 Answer 1

  1. express does not support FCI. I think the meaning of any means any production edition and this is not express, usually.

  2. sql server express support replication as subscriber only: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15#Replication About failover, you can't fail over on subcriber-only members and, in the case you are studing, HA is reached with the help of Availability Groups. So definitely throw away sql express to have better options for HA and DR.

  • Express Edition is supported in production but intended mostly for scenarios like desktop, branch office, small business, and factory floor. Jan 15, 2022 at 13:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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