locked
SQL Server High Availability Options RRS feed

  • Question

  • Can I implement a high availability solution for one of my SQL Server databases, but I'm not sure of which option to implement to satisfy my company's needs?
    Tuesday, September 15, 2015 5:10 AM

Answers

  • AlwaysON is a new feature shipping with SQL Server 2012 and is an alternative to database mirroring. AlwaysON uses groups called Availability Groups, which are groups that contain selected databases that will fail over together if a failure should occur

    Tuesday, September 15, 2015 6:14 AM

All replies

  • AlwaysON is a new feature shipping with SQL Server 2012 and is an alternative to database mirroring. AlwaysON uses groups called Availability Groups, which are groups that contain selected databases that will fail over together if a failure should occur

    Tuesday, September 15, 2015 6:14 AM
  • There are different types of high availability solutions. This depends on your RTO & RPO.

    simple words how much data loss can you afford and how much Down time can you afford.

    Depending on your requirement you can implement any of the below solutions.

    1) Logshipping

    2) Mirroring

    3) Replication

    4) Clustering

    5) Always On availability groups.

    These features are not available in all versions and editions of SQL server. So all of these solutions may not suitable to your organisation. 

    Tuesday, September 15, 2015 6:31 AM
  • Can I implement a high availability solution for one of my SQL Server databases, but I'm not sure of which option to implement to satisfy my company's needs?

    Well your question is too open ended you have to tell us about your environment so that we can suggest you appropriate solution.

    You have lot off options like mirroring, AOAG, Clustering , Logshipping but what you can use depends on version edition and cost


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP


    Tuesday, September 15, 2015 7:22 AM
  • What exactly do you want to achieve? Automatic Failover? No data loss? Single storage? Multi Storage? 2 Nodes? More Nodes? Multiple Datacenters?
    Tuesday, September 15, 2015 5:55 PM