Implementation of Microsoft SQL Server using ‘AlwaysOn’ for High Availability and Disaster Recovery without Shared Storage
Abstract
It is important for any organization to handle increase in data; normally this is the job of the DBA in organization to take care of this data growth, along with its protection and its availability. High availability of data is also most important for organizations, for that purpose, shared storage is usually the solution, for example, SAN or NAS storage as Microsoft Cluster Database instances. Mostly Organization does not have shared storage in their infrastructure, which was required for Microsoft cluster SQL database instance; due to that they used other native methods to implement like log shipping or database mirroring, which was not efficient method for high-availability and disaster-recovery solution. After that, Microsoft introduced native method called SQL AlwaysOn method that could be implemented without using SAN and NAS storage method to implement high availability and disaster recovery without using shared storage. SQL AlwaysOn option is using only Microsoft cluster service and shared folder between the nodes. This paper written for DBA and System Administrators; and is implementation of Microsoft SQL Database tier step by step.
Full Text:
PDFReferences
Hayat, Z., & Soomro, T. R. (2016). Implementation of oracle real application cluster. Review of Computer Engineering Studies, 3(4), 81-85.
Mehra, P., & Mishra, S. (2012). SQLCAT: SQL Server HA and DR Design Patterns, Architectures, and Best Practices Using Microsoft SQL Server 2012 AlwaysOn. Retrieved from https://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI316
Nawaz, R., & Soomro, T. R. (2013). Role of Oracle Active Data Guard in High Availability Database Operations. International Journal of Applied Information System, Foundation of Computer Science, New York, USA.
Otey, M. (2011). Microsoft SQL Server 2012: AlwaysOn Availability Groups Feature. Retrieved from http://www.itprotoday.com/microsoft-sql-server/microsoft-sql-server-2012-alwayson-availability-groups-feature
Ozar, B. (2010). SQL Server 2012 AlwaysOn Availability Groups Rock - Brent Ozar Unlimited®. Retrieved from https://www.brentozar.com/archive/2010/11/sql-server-denali-database-mirroring-rocks/
Ray, M., Guyer, C., & Vance, J. (2017). Database Mirroring and Log Shipping (SQL Server). Retrieved from https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-and-log-shipping-sql-server?view=sql-server-2017
Sack, J. (2012). AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups. Retrieved from https://www.sqlskills.com/blogs/joe/alwayson-architecture-guide-building-a-high-availability-and-disaster-recovery-solution-by-using-alwayson-availability-groups/
Sack, J., & Mishra, S. (2012). AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups. Retrieved from http://download.microsoft.com/download/d/2/0/d20e1c5f-72ea-4505-9f26-fef9550efd44/building%20a%20high%20availability%20and%20disaster%20recovery%20solution%20using%20alwayson%20availability%20groups.docx
Thomas, M., Guyer, C., & Vance, J. (2017). Always On Failover Cluster Instances (SQL Server). Retrieved from https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server?view=sql-server-2017
Weiner, M., Mishra, S., & He, M. (2011). SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance. Retrieved from https://blogs.technet.microsoft.com/minutes_on_bi/2011/12/22/sql-server-2012-alwayson-multisite-failover-cluster-instance/
DOI: http://dx.doi.org/10.22555/ijelcs.v3i1.1891
Refbacks
- There are currently no refbacks.
Copyright (c) 2018 International Journal of Experiential Learning & Case Studies
This work is licensed under a Creative Commons Attribution 4.0 International License.
Comments on this article
by skin clinic (2018-07-10)
by brueno marsza (2018-07-26)
by Cassiano Grasseto (2018-10-30)
by Cassiano Grasseto (2018-10-31)
by Cassiano Grasseto (2018-10-31)
by Cassiano Grasseto (2018-10-31)
by Cassiano Grasseto (2018-10-31)
by vla ud (2018-11-06)
by Emily Rose (2018-11-07)
by Cassiano Grasseto (2018-11-07)
by Cassiano Grasseto (2018-11-07)
by sillas belucio (2018-11-08)
by Luan Perera (2018-11-08)
by Shirley Hildebrant (2018-11-10)
by sillas belucio (2018-11-11)
by Mr Min zukii2 (2018-11-16)
by sillas belucio (2018-11-17)
by italo SILVA (2018-11-27)
by sillas belucio (2018-11-27)
by le huyen1 (2018-11-28)
by monyet handsome (2018-12-01)
by sillas belucio (2018-12-01)
by Samy Dasn (2018-12-01)
by le huyen10 (2018-12-02)
by Jully Sany (2018-12-05)
by pirulexen pirulexen (2018-12-06)
by lylymai lyly mai (2018-12-07)
by christhanah1 christhanah1 (2018-12-12)
by Ricardo Brasil (2018-12-18)
by henry henry (2018-12-19)
by Kia Huggard (2018-12-21)
by Kristen Morrison (2018-12-24)
by Michael Miller (2018-12-26)
by sillas belucio (2018-12-27)
by sillas belucio (2018-12-27)
by sillas belucio (2018-12-30)
by golusingh SINGH (2019-01-09)
by alberd adams (2019-01-15)
by dave stuard (2019-01-15)
by Mai Xuân Tân kinhdonem quan12 (2019-01-25)
by HỨA VĂN TÂN (2019-01-29)
by HỨA VĂN TÂN (2019-01-29)
by Van Hai offers the cheapest 35-seater car rental for summer 2018 (2019-01-31)
by Sue TBricker (2019-02-08)
by Sue TBricker (2019-02-11)
by rinki verma (2019-02-13)
by payung77 admin payung oke (2019-02-14)
by nguyen leha (2019-03-13)
by Wagner Tomaz (2019-03-13)
by Wagner Tomaz (2019-03-15)
by Wagner Tomaz (2019-03-18)
by Wagner Tomaz (2019-03-20)
by Margene Dees (2019-03-21)
by Wagner Tomaz (2019-03-22)
by Wagner Tomaz (2019-03-22)
by Roberto Millington (2019-06-04)
by Fahad Abdul (2019-06-08)
by Kevin Jones (2019-07-01)
by uydf sdb (2019-07-30)
by Ruior Biurga (2019-08-03)
by Ruior Biurga (2019-08-03)
by Kayleigh Grayson (2019-08-20)
by Trevor Ingalls (2019-08-20)
by Yvonne Sinnett (2019-08-20)
by Shirleen Twopeny (2019-08-20)
by Earnest Loane (2019-08-26)
by Clayton Manns (2019-09-03)
by Yvonne Sinnett (2019-09-13)
by Kayleigh Grayson (2019-09-13)
by srgr dsgr (2019-10-02)
by sebn sdgb (2019-10-02)
by kentangsakti kentang pasti sakti (2019-10-12)
by jkps adfe (2019-10-25)
by sdrtg rena (2019-10-25)
by IDN Poker (2019-11-02)
by yuol frda (2019-11-15)
by ytep dsec (2019-11-15)
by opds gfrs (2019-11-15)
by CARLA BONOMO (2019-12-18)
by CARLA BONOMO (2019-12-18)
by CARLA BONOMO (2019-12-18)
by Aracely Crick (2019-12-20)
by Comprar Maquininha de Credito (2020-01-06)
by mai quockhanh (2020-01-07)
by Sylvester Fairfield (2020-01-08)
by Alisia Behrens (2020-01-09)
by Dwayne Jephcott (2020-01-10)
by Tracie Lack (2020-01-13)
by Roderick Flower (2020-01-15)
by Brittney Vogel (2020-01-22)
by Reina Hackler (2020-01-23)
by Everett Wahl (2020-01-24)
by Latasha Collick (2020-01-25)
by Randall Drennan (2020-01-25)
by Geri Finnan (2020-01-27)
by Bonny MacDevitt (2020-01-28)
by Sherlyn Butters (2020-01-30)
by Mildred Minaya (2020-02-03)
by Senha Caixa (2020-02-03)
by Odessa Cockerill (2020-02-07)
by gery husley (2020-02-13)
by Arron Beckham (2020-02-19)
by Dwight Whinham (2021-02-24)
by Dwight Whinham (2021-03-01)
by Dwight Whinham (2021-03-04)
by Dwight Whinham (2021-03-08)
by Dwight Whinham (2021-03-13)