Good afteroon,
Is it possbile to HA the server the Database sits on? i know it is possible to HA the Orion box. but we are wondering if it is possible to do the same for the Database server?
If you're in need of a high availability solution for your SQL database server, our recommendation is to use AlwaysOn Availability groups or SQL Clustering. Both are native features available in MSSQL Server
Beware that availability groups do mean a transaction-logged database (instead of simple mode). This is discouraged for performance reasons.
SQL Clustering is replicating the data at the block level (ie disk level) which is why it needs no transaction logs to function.
I wouldn't say it's discouraged as such, but it does come with a clear caveat that you are potentially trading performance for availability/reslience. If that's acceptable to you then go for it.
We're currently using Neverfail....I'm wondering if that's a better solution?
