Implementation of Microsoft SQL Server using ‘AlwaysOn’ for High Availability and Disaster Recovery without Shared Storage
Journal Title: International Journal of Experiential Learning & Case Studies - Year 2018, Vol 3, Issue 1
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 don’t 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.
Authors and Affiliations
Zulqarnain Hayat, Tariq Rahim Soomro
Keywords
Related Articles
- EP ID EP318099
- DOI -
- Views 95
- Downloads 0
Managing English Teaching Outcomes in Universities: An Experiential Learning Case Study of ESL/EFL Interventions
In countries where English is a foreign language, universities are expected to enhance the communication skills of their students after overcoming the deficiencies that they typically carry over from their schooling year...
Importance of Public Relations in New Business
Understanding the true meaning of public relations will never be classified as a science because it is an ever-changing process much like a research process. There are continuous additions and subtractions being made; so...
Attitude of Business Students towards E-Commerce: A Case Study
This case study assesses the attitude of business students towards e-commerce subject offered in business schools comparing it with different other business subjects such as marketing, human resource, finance, and supply...
Samsonite: Case Study
This case study aimed at shedding light on the new emerging trends of busi¬ness observed in the Asian region. Today, big multinationals are learning from Asia and applying best practices, developed in this continent, in...
Changing the Conventional Way of Home Maintenance
It was the morning of Sunday 25th March, where a group of friends were sitting on a roadside café discussing about their life and future endeavors. While some of them wished tojoin service sector as the norm suggested, Q...