Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I saw that this is the feature of AlwaysOn for SQL Server 2012. Can anyone explain the meaning of this? I mean can anyone give example or scenario? SQL Server on Hyper-V SQL Server instances hosted on Hyper-V environment get the additional benefit of Live Migration which allows migration of virtual machines without any downtime. This allows administrators to do maintenance operations on the host without impacting applications.

And how is this different from SQL Server 2008 R2?

share|improve this question

I don't really want to answer with a link, but it's hard to beat Ozar when it comes to database stuff, so... well, here's his take.

Better scalability, high availability functions and disaster recovery are the main highlights. Try doing that with an older MSSQL cluster, and you'd usually end up with a splitting migraine and an almost working solution at the end of it.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.