Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Network Performance Monitor (NPM) > MS SQL Server Replication in SolarWinds Orion Database

MS SQL Server Replication in SolarWinds Orion Database

Created by Magdalena.Markova, last modified by Magdalena.Markova on Feb 08, 2017

Views: 374 Votes: 1 Revisions: 8

Overview

SQL Replication is a Microsoft technology for sharing a database across multiple SQL servers. Orion is fully compatible with many forms of SQL Replication but some cause problems. 

 

Supported SQL Replication Technologies:

 

Unsupported SQL Replication Technologies:

 

Environment

  • All Orion Core products
  • Microsoft SQL Server

Detail 

All SQL Replication technologies may cause performance issues. Please consult your Database Administrator to verify Physical Requirements before enabling any Replication technology.

 

See: https://technet.microsoft.com/en-us/library/ms152479(v=sql.105).aspx.

 

Replication has several common uses:

 

High Availability

SQL Server has several HA options all of which require some form of Replication. The most common is SQL Always On which can provide Automatic Failover for SQL databases. This may require Merge Replication which is not supported because of the GUID requirement for Primary Keys in our Database. 

 

See: https://msdn.microsoft.com/en-us/library/hh710046.aspx.

 

Disaster Recovery

Disaster Recovery for SQL Servers can be accomplished using Database Mirroring, Log Shipping, Transaction Log Replication, Snapshot Replication or by using SQL Backups.

 

See: https://support.microsoft.com/en-us/kb/822400.

 

Distributed Storage Applications

SQL Database Mirroring can be used to make the same Database available across multiple Data Centers. This can be useful for Distributed Data Applications however this is not usually compatible with HA or DR. 

 

See: https://msdn.microsoft.com/en-us/library/aa479364.aspx.

 

Microsoft References

 

SQL Server https://msdn.microsoft.com/library/m...(v=sql.1).aspx
SQL Translog Replication  https://msdn.microsoft.com/en-us/lib.../ms151176.aspx
SQL Replication https://msdn.microsoft.com/en-us/lib.../ms151198.aspx
SQL Log Shipping https://msdn.microsoft.com/en-us/lib.../ms151224.aspx
SQL DB Mirroring https://msdn.microsoft.com/en-us/lib.../ms151799.aspx
SQL Snapshot Replication https://msdn.microsoft.com/en-us/lib.../ms151832.aspx
SQL Merge Replication https://msdn.microsoft.com/en-us/lib.../ms152746.aspx
SQL Always On https://msdn.microsoft.com/en-us/lib.../ff877884.aspx
SQL PK https://technet.microsoft.com/en-us/...=sql.105).aspx
SQL Distributed database https://msdn.microsoft.com/en-us/lib.../aa479364.aspx
SQL Replication Performance Considerations https://technet.microsoft.com/en-us/library/ms152479(v=sql.105).aspx

Concepts

High Availability https://en.wikipedia.org/wiki/High_availability
Disaster Recovery https://en.wikipedia.org/wiki/Disaster_recovery
Distributed Data  https://en.wikipedia.org/wiki/Distributed_data_store

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

 

 

Last modified
06:21, 8 Feb 2017

Tags

Classifications

Public