Solved

HA on SQL 2014?

Posted on 2015-02-12
2
74 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 50

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
TSQL remove duplicates from different columns 14 52
Sorting a SQL script 5 41
how to resize column length with primary ket 4 34
Access PS SQLSERVER from powershell 1 30
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

739 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