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?
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.
danielrosenthal wrote:
We're currently using Neverfail....I'm wondering if that's a better solution?
If that's working for you, then it's the best possible solution.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.