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 103
- Downloads 0
Teacher Professional Education and Development: A Case Study
The case study research sought to explore whether school managers and teachers possessed knowledge of models of staff development and which models were in use in the private high school chosen for the study. Interviews o...
Express TV: Competing In a Cluttered World of Media for Consumer Preferences and Viewership Patterns
Express News TV Channel found some reports that their TV channel viewership was declining. In Pakistan, however, the viewership data is managed, still the system is not properly managed and has many loopholes. This can b...
Need Analysis of Business Students’ Preferences: A Holistic approach to Experiential Learning
The study conducts a need analysis for business students’ preference with regards to experiential learning. Two parallel questionnaires were administered to business students (N=125): i) Original version of Course Experi...
Differentiating Through Liberal Arts in University Education
"Make Habib University your home for the coming four years. You won’t find a more supportive environment anywhere else. You’ll encounter challenges you have not experienced prior, but you will be surrounded by talented,...
Paid Academic Writing Services: A Perceptional Study of Business Students
It seems challenging to detect the beneficiary students of the Academic Paid Writing Services, which refers to a practice in which authors or students appoint professional writers to produce scholarly work (including res...