1

I am looking at building at reliable database with Microsoft SQL Server, with mirroring and automatic failover. The SQL Server here is standard version, not enterprise one so High Availability Solutions is not supported.

Just wonder if there is any third-party tool we can use as an alternative?

It's SQL Server 2014 I'm using.

closed as off-topic by TomTom, Philᵀᴹ, James Anderson, Vérace, Tom V Jun 29 '16 at 8:55

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – TomTom, Philᵀᴹ, James Anderson, Vérace, Tom V
If this question can be reworded to fit the rules in the help center, please edit the question.

  • Do you think any 3rd party tool that does this is going to be cheaper than upgrading to SQL Server Enterprise edition? – Greenstone Walker Jun 29 '16 at 2:00
  • @GreenstoneWalker Is there any? – ydoow Jun 29 '16 at 2:02
  • What are your requirements? Have you considered transactional replication or logshipping since you are on standard edition ? – Kin Shah Jun 29 '16 at 2:56
  • @Kin for this I'm hoping to have a secondary server up running for automatic failover if the primary one is down in case, without changing the connection details from my website. – ydoow Jun 29 '16 at 3:04
3

I'm not sure I understand, you state you are going to use mirroring, in standard it is still available so why can't you use that? Or is the question that is there anything else available?

You can also use Failover clustering in standard edition, the limit is you can only use 2 nodes but I don't see that as an issue for your request.

Also, if you are using any virtualization technology (VMware, Hyper-V etc) there may be options that you can speak to your virtualization about which are edition (not to mention software) agnostic.

Mat

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