Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

HA on SQL 2014?

Posted on 2015-02-12
2
Medium Priority
?
81 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 400 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 53

Accepted Solution

by:
Vitor Montalvão earned 1600 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

578 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