Roland, I would suggest a SQL cluster to provide high availability for your SQL DB's. Also, make sure you have a decent SQL backup strategy.
We use SQL clustering heavily in our organization for lots of applications. We are currently in the same boat with our SCOM DB's, but we have plans to migrate them to our SQL cluster before too long. From: [email protected] [mailto:[email protected]] On Behalf Of Roland Janus Sent: Monday, August 18, 2014 7:32 AM To: [email protected] Subject: [msmom] SQL Always on? My current design is two Mgt servers for some HA (no network yet) and the Ops and DW DB's on separate servers. But that makes SQL still single point of failure. So should I do Always on for both doubling SQL? Or can I do Always on with just those two, putting a copy of each to the other? OpsDB and DW DB on both? Should one fail, I still have both DB's but the same number of servers? Does that make even sense? :) Is there a point of doing two MgtServers for HA with just one SQL for each DB? -roland
