• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 85
  • Last Modified:

HA on SQL 2014?


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.
Help DeskLF
Help DeskLF
2 Solutions
Aneesh RetnakaranDatabase AdministratorCommented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now