Solved

HA on SQL 2014?

Posted on 2015-02-12
2
69 Views
Last Modified: 2015-02-16
Hello,

I was wondering if there was an option in SQL 2014 for HA? Lets say we have a sql server in NY and one in LA, we would like to be able to configure it so that if something happens in the LA office we can run out of NY, automatically or just by putting a command, and vice versa.
0
Comment
Question by:Help DeskLF
2 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 100 total points
ID: 40606576
Base on the network speed, how much data you can loss and the edition of the SQL Server, you can have any of these options
- log shipping
- Mirroring
0
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 400 total points
ID: 40607427
Don't use Mirroring anymore. It's deprecated and has been replaced by AlwaysOn feature.

You can also use a regional cluster so it can failover from NY to LA and vice-versa.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel conversion issue with Sql server 14 46
Solution for warm standby SQL server 20 38
SQL Server Question 5 25
Error running stored procedure 11 15
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now