Implementation of Microsoft SQL Server using ‘AlwaysOn’ for High Availability and Disaster Recovery without Shared Storage

Zulqarnain Hayat; Tariq Rahim Soomro

doi:10.22555/ijelcs.v3i1.1891

Implementation of Microsoft SQL Server using ‘AlwaysOn’ for High Availability and Disaster Recovery without Shared Storage

Zulqarnain Hayat, Tariq Rahim Soomro

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:

PDF

References

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