We may earn an affiliate commission when you visit our partners.
Practical SQL Server High Availability and Disaster Recovery
Russ Thomas
Russ Thomas
Supporting high availability and disaster recovery are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. Whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up, this course will compare and contrast the many features, techniques, and concepts available in SQL Server to meet your individual needs.
Read more
Supporting high availability and disaster recovery are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. Whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up, this course will compare and contrast the many features, techniques, and concepts available in SQL Server to meet your individual needs.
Read more
Supporting high availability and disaster recovery are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. Whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up, this course will compare and contrast the many features, techniques, and concepts available in SQL Server to meet your individual needs.
Congratulations, you’re the DBA. Along with all the rights, privileges, and prestige that comes with that. It also means you are responsible for not only the uptime and guaranteed availability of your database servers but also the ability for any of those servers to quickly recovery from any disaster imaginable. Supporting these two areas are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. This course will compare and contrast the many features, techniques, and concepts available in SQL Server that will meet your individual needs whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up.
Register for this course and see more details by visiting:
OpenCourser.com/course/lbquky/practical
What's inside
Syllabus
Understanding High Availability vs. Disaster Recovery
Getting Familiar with the Transaction Log
Taking Backups and Implementing Log Shipping
Setting up Failover Clustering
Read more
Syllabus
Understanding High Availability vs. Disaster Recovery
Getting Familiar with the Transaction Log
Taking Backups and Implementing Log Shipping
Setting up Failover Clustering
Read more
Supporting Legacy Mirrors
Installing and Supporting AlwaysOn Availability Groups
Understanding Additional Approaches
Bringing It All Together
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Provides a comprehensive overview of high availability and disaster recovery for SQL Server, catering to both beginners and experienced DBAs
Covers a wide range of topics, including backups, log shipping, failover clustering, and AlwaysOn Availability Groups
Taught by Russ Thomas, a senior-level DBA with extensive experience in high availability and disaster recovery
Relevant for DBAs working in both large enterprises and startups, regardless of their budget constraints
May require learners to have some prior experience with SQL Server
Save this course
Save Practical SQL Server High Availability and Disaster Recovery to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Practical SQL Server High Availability and Disaster Recovery with these
activities:
Review High Availability Fundamentals
Show steps
Refreshes foundational understanding of high availability concepts and practices in SQL Server to provide a stronger foundation for the course.
Browse courses on
High Availability
Show steps
-
Review the definition of high availability and its benefits.
-
Discuss different approaches to achieving high availability in SQL Server.
-
Compare and contrast the advantages and disadvantages of each approach.
Complete practice exercises on transaction logs
Show steps
Gain hands-on experience working with transaction logs and enhance your understanding of their role in high availability and disaster recovery.
Show steps
-
Follow guided tutorials or online courses on transaction log management.
-
Set up a local SQL Server instance and practice creating, managing, and recovering from transaction logs.
-
Complete practice exercises and quizzes on transaction log concepts and operations.
Get Hands-on with Transaction Logging
Show steps
Provides practical experience in working with transaction logs in SQL Server, enhancing understanding and hands-on skills.
Browse courses on
Transaction Log
Show steps
-
Set up a test environment with SQL Server.
-
Generate transactions and examine the associated transaction log entries.
-
Explore advanced logging options and their impact on performance.
Seven other activities
Expand to see all activities and additional details
Show all ten activities
Follow tutorials on AlwaysOn Availability Groups
Show steps
Expand your knowledge of AlwaysOn Availability Groups by following guided tutorials that provide step-by-step instructions on their setup and management.
Show steps
-
Search for online tutorials or courses on AlwaysOn Availability Groups.
-
Follow the instructions provided in the tutorials to set up AlwaysOn Availability Groups on a local SQL Server instance.
-
Practice managing and monitoring AlwaysOn Availability Groups, including failover testing.
Attend a SQL Server High Availability User Group Meeting
Show steps
Connects students with industry professionals and experts, facilitating knowledge exchange and networking opportunities related to high availability in SQL Server.
Browse courses on
High Availability
Show steps
-
Identify a local SQL Server user group that focuses on high availability.
-
Attend a meeting and engage with other members.
-
Share your own experiences and knowledge with the group.
Design and Implement a Backup and Log Shipping Solution
Show steps
Challenges students to apply their knowledge by designing and implementing a comprehensive backup and log shipping solution, solidifying their skills.
Browse courses on
Backups
Show steps
-
Analyze business requirements and determine backup and recovery objectives.
-
Design a backup strategy using appropriate backup types and schedules.
-
Configure and test log shipping to ensure continuous availability.
Create a presentation on failover clustering
Show steps
Deepen your comprehension of failover clustering by creating a presentation that covers its concepts, benefits, and implementation.
Browse courses on
Failover Clustering
Show steps
-
Gather information from course materials, textbooks, and online resources on failover clustering.
-
Design the structure and content of your presentation, including an introduction, main sections, and conclusion.
-
Create slides that visually represent the key concepts and benefits of failover clustering.
-
Practice delivering your presentation to receive feedback and improve your clarity and effectiveness.
Configure and Troubleshoot Failover Clustering
Show steps
Provides repetitive exercises to reinforce understanding and troubleshooting skills related to failover clustering, improving proficiency in real-world scenarios.
Browse courses on
Failover Clustering
Show steps
-
Set up a failover cluster in a test environment.
-
Simulate and troubleshoot common failover scenarios.
-
Optimize cluster performance and availability.
Participate in a SQL Server High Availability Hackathon
Show steps
Offers a highly engaging and competitive environment to test and showcase skills in designing and implementing high availability solutions, encouraging creativity and problem-solving.
Browse courses on
High Availability
Show steps
-
Identify a hackathon focused on SQL Server high availability.
-
Form a team or work individually to develop a solution.
-
Present your solution and demonstrate its effectiveness.
Implement AlwaysOn Availability Groups in a Real-World Scenario
Show steps
Provides an opportunity to apply skills in a realistic setting by implementing AlwaysOn Availability Groups, solidifying knowledge and increasing confidence.
Show steps
-
Gather requirements and design an AlwaysOn Availability Group solution.
-
Deploy and configure AlwaysOn Availability Groups in a live environment.
-
Monitor and maintain the Availability Group to ensure high availability and performance.
-
Troubleshoot and resolve any issues encountered during implementation or operation.
Review High Availability Fundamentals
Show steps
Refreshes foundational understanding of high availability concepts and practices in SQL Server to provide a stronger foundation for the course.
Browse courses on
High Availability
Show steps
Show steps
Show steps
- Review the definition of high availability and its benefits.
- Discuss different approaches to achieving high availability in SQL Server.
- Compare and contrast the advantages and disadvantages of each approach.
Complete practice exercises on transaction logs
Show steps
Gain hands-on experience working with transaction logs and enhance your understanding of their role in high availability and disaster recovery.
Show steps
Show steps
Show steps
- Follow guided tutorials or online courses on transaction log management.
- Set up a local SQL Server instance and practice creating, managing, and recovering from transaction logs.
- Complete practice exercises and quizzes on transaction log concepts and operations.
Get Hands-on with Transaction Logging
Show steps
Provides practical experience in working with transaction logs in SQL Server, enhancing understanding and hands-on skills.
Browse courses on
Transaction Log
Show steps
Show steps
Show steps
- Set up a test environment with SQL Server.
- Generate transactions and examine the associated transaction log entries.
- Explore advanced logging options and their impact on performance.
Seven other activities
Expand to see all activities and additional details
Show all ten activities
Follow tutorials on AlwaysOn Availability Groups
Show steps
Expand your knowledge of AlwaysOn Availability Groups by following guided tutorials that provide step-by-step instructions on their setup and management.
Show steps
Show steps
Show steps
- Search for online tutorials or courses on AlwaysOn Availability Groups.
- Follow the instructions provided in the tutorials to set up AlwaysOn Availability Groups on a local SQL Server instance.
- Practice managing and monitoring AlwaysOn Availability Groups, including failover testing.
Attend a SQL Server High Availability User Group Meeting
Show steps
Connects students with industry professionals and experts, facilitating knowledge exchange and networking opportunities related to high availability in SQL Server.
Browse courses on
High Availability
Show steps
Show steps
Show steps
- Identify a local SQL Server user group that focuses on high availability.
- Attend a meeting and engage with other members.
- Share your own experiences and knowledge with the group.
Design and Implement a Backup and Log Shipping Solution
Show steps
Challenges students to apply their knowledge by designing and implementing a comprehensive backup and log shipping solution, solidifying their skills.
Browse courses on
Backups
Show steps
Show steps
Show steps
- Analyze business requirements and determine backup and recovery objectives.
- Design a backup strategy using appropriate backup types and schedules.
- Configure and test log shipping to ensure continuous availability.
Create a presentation on failover clustering
Show steps
Deepen your comprehension of failover clustering by creating a presentation that covers its concepts, benefits, and implementation.
Browse courses on
Failover Clustering
Show steps
Show steps
Show steps
- Gather information from course materials, textbooks, and online resources on failover clustering.
- Design the structure and content of your presentation, including an introduction, main sections, and conclusion.
- Create slides that visually represent the key concepts and benefits of failover clustering.
- Practice delivering your presentation to receive feedback and improve your clarity and effectiveness.
Configure and Troubleshoot Failover Clustering
Show steps
Provides repetitive exercises to reinforce understanding and troubleshooting skills related to failover clustering, improving proficiency in real-world scenarios.
Browse courses on
Failover Clustering
Show steps
Show steps
Show steps
- Set up a failover cluster in a test environment.
- Simulate and troubleshoot common failover scenarios.
- Optimize cluster performance and availability.
Participate in a SQL Server High Availability Hackathon
Show steps
Offers a highly engaging and competitive environment to test and showcase skills in designing and implementing high availability solutions, encouraging creativity and problem-solving.
Browse courses on
High Availability
Show steps
Show steps
Show steps
- Identify a hackathon focused on SQL Server high availability.
- Form a team or work individually to develop a solution.
- Present your solution and demonstrate its effectiveness.
Implement AlwaysOn Availability Groups in a Real-World Scenario
Show steps
Provides an opportunity to apply skills in a realistic setting by implementing AlwaysOn Availability Groups, solidifying knowledge and increasing confidence.
Show steps
Show steps
Show steps
- Gather requirements and design an AlwaysOn Availability Group solution.
- Deploy and configure AlwaysOn Availability Groups in a live environment.
- Monitor and maintain the Availability Group to ensure high availability and performance.
- Troubleshoot and resolve any issues encountered during implementation or operation.
Career center
Learners who complete Practical SQL Server High Availability and Disaster Recovery will develop knowledge and skills
that may be useful to these careers:
Systems Engineer
Systems Engineer
Systems Engineers design, implement, and maintain computer systems, including databases. This course will help Systems Engineers who need to make sure that databases are highly available and protected against disasters. Because this course is vendor-specific, having a background in SQL Server is helpful as well.
Data Architect
Data Architect
Data Architects design and build enterprise-level data management solutions, including disaster recovery and high availability systems. The skills taught in this course will help a Data Architect design systems that minimize downtime and protect against data loss. Because this course is vendor-specific, having a background in SQL Server is helpful as well.
Database Administrator
Database Administrator
Database Administrators are responsible for ensuring the integrity and availability of an organization's databases. This course will prove useful to anyone who aspires to become a Database Administrator. In this course, you will build a foundation in the many features and functionalities of SQL Server that enable high availability and disaster recovery. Because this course is vendor-specific, having a background in SQL Server is helpful as well.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts use data analysis and visualization tools to help organizations understand data and make informed decisions. This course will be useful to Business Intelligence Analysts who work with databases and need to ensure that data is available when needed and protected against loss. Because this course is vendor-specific, having a background in SQL Server is helpful as well.
Cloud Engineer
Cloud Engineer
Cloud Engineers design, build, and maintain cloud-based systems, including databases. This course will help Cloud Engineers who need to provision and manage high availability and disaster recovery solutions for SQL Server in the cloud.
Database Developer
Database Developer
Database Developers design and develop database applications. This course will prove useful to anyone who aspires to become a Database Developer, particularly those who work with SQL Server and need to understand high availability and disaster recovery mechanisms.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. This course may be useful to Software Engineers who work on data-driven applications and need to understand how to ensure high availability and disaster recovery.
IT Manager
IT Manager
IT Managers are responsible for managing all aspects of an organization's IT infrastructure, including databases. This course will help IT Managers who are responsible for ensuring the high availability and disaster recovery of their organization's databases.
Data Scientist
Data Scientist
Data Scientists use data analysis and modeling techniques to extract insights from data. This course may be useful to Data Scientists who work with SQL Server databases and need to understand how to ensure data availability and protect against data loss.
DevOps Engineer
DevOps Engineer
DevOps Engineers bridge the gap between development and operations, working on both software development and IT infrastructure. This course may be useful to DevOps Engineers who work on projects that involve SQL Server and need to implement high availability and disaster recovery solutions.
Information Security Analyst
Information Security Analyst
Information Security Analysts protect an organization's networks, systems, and data from unauthorized access, use, disclosure, disruption, modification, or destruction. This course may be useful to Information Security Analysts who assess the security of an organization's databases, design security measures, and respond to security incidents.
Network Engineer
Network Engineer
Network Engineers design, implement, and maintain computer networks. This course may be useful to Network Engineers who need to ensure high availability and disaster recovery of network infrastructure, including databases.
Project Manager
Project Manager
Project Managers plan, execute, and close projects. This course may be useful to Project Managers who are involved in projects that require high availability and disaster recovery of databases.
Technical Writer
Technical Writer
Technical Writers create documentation for technical products and services. This course may be useful to Technical Writers who need to write documentation on SQL Server high availability and disaster recovery features.
Sales Engineer
Sales Engineer
Sales Engineers help customers understand and purchase technical products and services. This course may be useful to Sales Engineers who sell SQL Server high availability and disaster recovery solutions.
For more career information including salaries, visit:
OpenCourser.com/course/lbquky/practical
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Practical SQL Server High Availability and Disaster Recovery.
Provides a comprehensive overview of SQL Server high availability and disaster recovery, covering both on-premises and cloud-based solutions. It valuable resource for DBAs and system administrators who want to ensure the availability and recoverability of their SQL Server databases.
Focuses specifically on disaster recovery for SQL Server, providing detailed guidance on developing and implementing a disaster recovery plan. It practical guide for DBAs and system administrators who need to ensure the continuity of their SQL Server databases in the event of a disaster.
Provides a comprehensive overview of SQL Server database backups and recovery. It valuable resource for DBAs and system administrators who need to ensure the recoverability of their SQL Server databases.
Provides detailed guidance on implementing and managing SQL Server log shipping. It valuable resource for DBAs and system administrators who need to ensure the disaster recovery of their SQL Server databases.
Provides a collection of practical recipes for solving common SQL Server failover clustering problems. It valuable reference for DBAs and system administrators who need to troubleshoot and resolve failover clustering issues.
Provides best practices for implementing and managing SQL Server log shipping. It valuable resource for DBAs and system administrators who want to ensure the reliability and efficiency of their log shipping configuration.
Provides a collection of practical recipes for solving common SQL Server replication problems. It valuable reference for DBAs and system administrators who need to troubleshoot and resolve replication issues.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/lbquky/practical
Share
Similar courses
Here are nine courses similar to
Practical SQL Server High Availability and Disaster Recovery.
Managing Azure SQL Database for the SQL Server DBA
OpenCourser.com/course/xiwpeg/managing
Managing Azure SQL Database for the SQL Server DBA
Most relevant
Implementing Windows Server DR in an Azure Environment
OpenCourser.com/course/wmrfuk/implementing
Implementing Windows Server DR in an Azure Environment
How To Begin Your Career As a SQL Server DBA
OpenCourser.com/course/2p1p03/how
How To Begin Your Career As a SQL Server DBA
Oracle DBA 11g/12c - Database Administration for Junior DBA
OpenCourser.com/course/ivc9cm/oracle
Oracle DBA 11g/12c - Database Administration for Junior...
Implementing Nutanix High Availability and Disaster Recovery
OpenCourser.com/course/lby4uz/implementing
Implementing Nutanix High Availability and Disaster...
Designing a Disaster Recovery Strategy on Microsoft Azure
OpenCourser.com/course/lqxlz9/designing
Designing a Disaster Recovery Strategy on Microsoft Azure
Designing and Implementing High Availability and Disaster Recovery for SAP Workloads on Azure
OpenCourser.com/course/pl1whi/designing
Designing and Implementing High Availability and Disaster...
Citrix ADC High Availability and Disaster Recovery
OpenCourser.com/course/wiazh2/citrix
Citrix ADC High Availability and Disaster Recovery
Windows Server 2022: Implement Disaster Recovery
OpenCourser.com/course/2ek2g9/windows
Windows Server 2022: Implement Disaster Recovery
Time
280 hours
Level
Intermediate
Via
Pluralsight
Instructor
Russ Thomas
Language
English
Good to know
Provides a comprehensive overview of high availability and disaster recovery for SQL Server, catering to both beginners and experienced DBAs
Covers a wide range of topics, including backups, log shipping, failover clustering, and AlwaysOn Availability Groups
Taught by Russ Thomas, a senior-level DBA with extensive experience in high availability and disaster recovery
Relevant for DBAs working in both large enterprises and startups, regardless of their budget constraints
May require learners to have some prior experience with SQL Server
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser