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.