nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Orion and SQL Mirroring

eanthes

Does, or can, Orion support SQL mirroring? If yes, how is it set up? If no, can it be added as a feature Request?

Find more posts tagged with

Accepted answers

All comments

MarieB

Hi eanthes--

Here are some posts I found on mirroring. Can they help your specific installation? If not, post back and I'll make sure the PM sees it.

eanthes

I don’t think these have anything to do with what we’re trying to do. These have to do with disk mirroring.

We need to mirror the actual DB between two servers. Here is a Microsoft TechNet article: http://technet.microsoft.com/en-us/library/cc917680.aspx

This should be achieved through using a DSN connection, or by adding to the connection string in Orion.

Ernie

MarieB

Hi Ernie--

I'll let the product manager have a look at this and get back to you.

Thx,

m_roberts

Mirroing SQL is something separate to Orion in the fact that the mirroing is done at the database level. Whether this is using log shipping, DBsnapshots or the various 3rd party apps available.

You dont give your reasons for mirroring, but in most situations mirroring is performed to place an instance of the SQL database at a remote DR location. Whether there is a mirrored, but service disabled, installation of Orion, which in the case of DR failover, the DR Orion will be configured to use the mirrored SQL server. When failing back to the primary site, the database is synchronised back to provide a consistent data collective.

bshopp

Ernie,

PM me via thwack and we can talk offline regarding some options for you to look into and I can gather more of your requirements.

Colly

Hi Brandon

We find ourselves in a similar situation with SQL DB mirroring. We are considering using log shipping instead of native DB mirroring. Have you any recommendations you can share?

Regards

Colly

FormerMember

I was wondering if there was anything new with this? We would like to use mirroring here with our Solarwinds products as well.

Our setup has two physical SQL servers at two different locations that mirror databases between the two. Our Orion install is a virtual server that is protected with SRM between those two locations. If we have to failover to the DR site, it would be nice if the solarwinds software could see that it cannot talk to the primary database and talk to the failoverpartner instead automatically.

cdummy

I'm curious, too, you get any responses on this point? I'm kind of sad the product manager took things offline in the previous posting.

bshopp

Don't be sad, I am always paying attention

Check this doc out we put together and see if it helps.

cdummy

Thanks for the speedy reply! I read through that doc and it appears that the MSSQL mirroring isn't supported (without the Failover Engine product, at least).

Taking a different tack, is there any way to specify via ODBC which database Orion NPM uses or is choosing the database only done via the database manager?

Seashore

As I understand Orion NPM does not support sql-mirroring but:

1: Does the failover component support that?
2: Can I edit the sql connection string manually? (Becouse the sql .net data provider supports it by using the "FAILOVER PARTNER=[MyMirrorServerName]")
2.1: If I can, where is it?

/Thomas

bshopp

The Failover Engine does not support SQL. Here is a doc we put together which outlines your options for SQL