Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

What is your MS SQL High Availability / Disaster Recovery Plan?

kausti2

We know we have HA Engines for our pollers, but what do you do with your MS SQL? What is your fail-over plan?

Find more posts tagged with

sql

Accepted answers

All comments

aLTeReGo

SQL AlwaysOn is the recommended solution for Orion HA, though SQL Clustering is another popular option.

jere557

aLTeReGo, are there any Solarwinds specific instructions for setting up the SQL AlwaysOn? While trying to configure AlwaysOn for a new install, it asks for a database. However, as this is a fresh install, there is no database yet. So my thought process is, install Orion on what will be our primary application server, so it build the database on one of the SQL servers (SQL Server A). Then set up the AlwaysOn for that database to replicate/move to a SQL server (SQL Server that can be read from both our data centers. After that, we'd rerun the config wizard to see the database that's AlwaysOn, on SQL Server B?

aLTeReGo

There's no special configuration on the Orion side needed. Simply specify listener name of the SQL AlwaysOn availability group rather than SQL instance name in database step of Configuration Wizard and away you go.

jere557

But with a new install, as there is no database to point to, would the order of operations be, install solarwinds to build the database, then build the Availability group for AlwaysOn? Or is there a way to build the alwayson so that we don't need to have a database yet? I just don't see a way, at the moment, to build the alwayson without specifying a database.

Thanks!

ckumarb

Is anyone implemented it?

ckumarb

I got confused here !!! is it required to run the configuration wizard on management server and APE's during the DR ?

aLTeReGo

ckumarb wrote:
I got confused here !!! is it required to run the configuration wizard on management server and APE's during the DR ?

No, there is zero requirement to run the Configuration Wizard on the server after a failover has occurred. Failovers are seamless and transparent events.

hpstech

Any feedback on those using AlwayOn considering the Recovery Mode requirements mentioned here:

Re: Running Solarwinds on Alwayson SQL cluster (database issues)

Robins

Hi,

I know this is old question but, recently I have read a blog on RedGate Simple Talk channel. It keeps all the information about HA(High Availability) and DR (Disaster Recovery). Here is the reference: https://www.red-gate.com/simple-talk/databases/sql-server/learn/sql-server-high-availability-and-disaster-recovery-plan/