OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Pluralsight logo

SQL Server

Understanding, Configuring and Troubleshooting Database Mirroring

Glenn Berry

Learn how to correctly configure and use SQL Server database mirroring, including troubleshooting common problems. This course is applicable to all versions of SQL Server and is aimed at DBAs, developers, and system administrators.

Read more

Learn how to correctly configure and use SQL Server database mirroring, including troubleshooting common problems. This course is applicable to all versions of SQL Server and is aimed at DBAs, developers, and system administrators.

SQL Server database mirroring is a very useful technology for high availability and disaster recovery, as well as for general purpose database movement, migration, and upgrades. In this course, SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring, you'll first learn the basics of database mirroring, its capabilities, and its limitations. Next, you'll explore how to prepare an environment for database mirroring, and then how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts. Then, you'll learn how to monitor a database mirroring environment and troubleshoot common problems. Finally, you'll discover how to use database mirroring for data migration and upgrading a database to a new version of SQL Server. When you've finished this course, you'll have the skills and knowledge to start configuring, using and troubleshooting database mirroring.

Enroll now

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off

What's inside

Syllabus

Course Overview
Introduction
Database Mirroring Overview
Preparing for Database Mirroring
Read more
Configuring Database Mirroring
Monitoring and Troubleshooting Database Mirroring
Migrating Data Using Database Mirroring

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Strengthens an existing foudnation for intermediate learners in database mirroring
Core skills for DBAs, developers, and system administrators who want to gain a deeper understanding of database mirroring
Covers unique perspectives in the area of database mirroring
Multi-modal with videos and discussions
Taught by Glenn Berry, an established instructor in the field of database mirroring

Save this course

Save SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring to your list so you can find it easily later:
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 SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring with these activities:
Organize and review course materials for better retention
Enhance your understanding by organizing and reviewing course materials to solidify your knowledge and improve recall.
Show steps
  • Compile lecture notes, assignments, and quizzes
  • Organize the materials in a logical and structured manner
  • Review the organized materials regularly
Review Database Mirroring Concepts
Refresh your knowledge of database mirroring before starting the course.
Browse courses on Database Mirroring
Show steps
  • Review your notes or course materials
  • Take a practice quiz or test
Review concepts of database mirroring and its role in disaster recovery
Refresh your knowledge of database mirroring concepts and its role in ensuring data availability and business continuity.
Browse courses on Database Mirroring
Show steps
  • Review the principles of database mirroring
  • Understand the different types of database mirroring modes
  • Explore the benefits and limitations of database mirroring for disaster recovery
Ten other activities
Expand to see all activities and additional details
Show all 13 activities
Review Fundamentals of Database Systems
Review the fundamental concepts of database systems to strengthen your understanding of database mirroring.
Show steps
  • Read Chapters 1-5
  • Complete the practice exercises at the end of each chapter
Join a Database Mirroring Study Group
Engage with peers to discuss and reinforce database mirroring concepts.
Browse courses on Database Mirroring
Show steps
  • Find a study group or online forum
  • Participate in discussions, ask questions, and share your knowledge
Follow Microsoft's Database Mirroring Tutorials
Supplement your learning by following Microsoft's official tutorials on database mirroring.
Browse courses on Database Mirroring
Show steps
  • Visit Microsoft's documentation website
  • Follow the step-by-step tutorials
SQL Server Database Mirroring Practice Exercises
Complete practice exercises to solidify your understanding of database mirroring concepts and configuration.
Browse courses on Database Mirroring
Show steps
  • Install SQL Server Management Studio
  • Set up two SQL Server instances for mirroring
  • Configure database mirroring using T-SQL scripts
Attend a Database Mirroring Workshop
Participate in a workshop to gain hands-on experience and expert guidance on database mirroring.
Browse courses on Database Mirroring
Show steps
  • Find a relevant workshop
  • Register and attend the workshop
  • Actively participate and ask questions
Configure database mirroring using T-SQL scripts
Practice configuring database mirroring using T-SQL scripts to gain hands-on experience and reinforce your understanding of the process.
Browse courses on Database Mirroring
Show steps
  • Review the T-SQL syntax for database mirroring configuration
  • Create a test environment for database mirroring
  • Develop T-SQL scripts to configure database mirroring
  • Execute the T-SQL scripts to configure database mirroring
  • Verify the configuration and test database mirroring functionality
Create a Database Mirroring Diagram
Enhance your understanding by creating a visual representation of a database mirroring setup.
Browse courses on Database Mirroring
Show steps
  • Use a whiteboard or drawing software
  • Draw the components involved in database mirroring, such as the principal and mirror databases, witness, and log shipping
Migrate a Database Using Database Mirroring
Apply your knowledge by migrating a database to a new server using database mirroring.
Browse courses on Database Mirroring
Show steps
  • Set up a source and destination database
  • Configure database mirroring between the databases
  • Perform the database migration
Create a data migration plan using database mirroring
Develop a comprehensive data migration plan using database mirroring to solidify your understanding of its practical application in data movement scenarios.
Browse courses on Data Migration
Show steps
  • Identify the source and target databases for migration
  • Design the database mirroring configuration for data migration
  • Create and configure database mirroring
  • Implement incremental data migration using database mirroring
  • Test and validate the data migration process
Deploy a high availability database mirroring solution
Gain practical experience by deploying a high availability database mirroring solution to reinforce your knowledge and prepare for real-world application.
Browse courses on High Availability
Show steps
  • Plan and design the high availability database mirroring solution
  • Configure and implement database mirroring
  • Configure monitoring and alerting for database mirroring
  • Test and validate the high availability solution
  • Deploy the high availability solution to production

Career center

Learners who complete SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring will develop knowledge and skills that may be useful to these careers:
DBA Architect
DBA Architects design, build, and maintain database systems. They are responsible for ensuring that data is properly stored, organized, and accessible. Taking this course can help build a foundation for a career as a DBA Architect by providing a deep understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for DBA Architect
Database Administrator Analyst
Database Administrator Analysts work with Database Administrators to design, build, and maintain database systems. They are responsible for writing and maintaining database documentation. Taking this course can help build a foundation for a career as a Database Administrator Analyst by providing a deep understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Database Administrator Analyst
Database Developer
Database Developers design, develop, and maintain databases. They use programming languages to create and manage databases, ensuring they are properly configured and troubleshooting any issues. Taking this course can help build a foundation for a career as a Database Developer by providing a deep understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Database Developer
Database Administrator
A Database Administrator is a computing professional who ensures an organization's databases are fully operational. They create and manage databases, ensuring they are properly configured and troubleshooting any issues. Database Administrators are typically responsible for planning, implementing, and maintaining database systems. Taking this course can help build a foundation for a career as a Database Administrator by providing a deep understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Database Administrator
Database Administrator Manager
Database Administrator Managers supervise and manage Database Administrators. They are responsible for planning, implementing, and maintaining database systems. Taking this course can help build a foundation for a career as a Database Administrator Manager by providing a deep understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Database Administrator Manager
Data Architect
Data Architects design, build, and manage data systems. They are responsible for ensuring that data is properly stored, organized, and accessible. Taking this course can help build a foundation for a career as a Data Architect by providing a deep understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Data Architect
Computer Systems Analyst
Computer Systems Analysts study an organization's current computer systems and procedures and design ways to improve them. They also recommend new computer systems and software. Taking this course can help build a foundation for a career as a Computer Systems Analyst by providing a deep understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Computer Systems Analyst
Systems Administrator
Systems Administrators ensure computer systems, including hardware, software, and networks, run smoothly and efficiently. They are responsible for installing, maintaining, and troubleshooting computer systems and software. Taking this course can help build a foundation for a career as a Systems Administrator by providing a deep understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Systems Administrator
Cloud Engineer
Cloud Engineers design, build, and maintain cloud computing systems. They are responsible for ensuring that cloud-based applications are properly configured and troubleshooting any issues. Taking this course may be useful for Cloud Engineers who want to gain a deeper understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Cloud Engineer
Data Analyst
Data Analysts collect, clean, and interpret data to help businesses make informed decisions. They use statistical techniques to analyze data and identify trends and patterns. Taking this course may be useful for Data Analysts who want to gain a deeper understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Data Analyst
Business Intelligence Analyst
Business Intelligence Analysts use data to help businesses make informed decisions. They collect, clean, and interpret data to identify trends and patterns. Taking this course may be useful for Business Intelligence Analysts who want to gain a deeper understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Business Intelligence Analyst
Data Scientist
Data Scientists use statistical techniques to analyze data and identify trends and patterns. They use this information to help businesses make informed decisions. Taking this course may be useful for Data Scientists who want to gain a deeper understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Data Scientist
Software Development Manager
Software Development Managers supervise and manage Software Engineers. They are responsible for planning, implementing, and maintaining software development projects. Taking this course may be useful for Software Development Managers who want to gain a deeper understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Software Development Manager
Information Security Analyst
Information Security Analysts protect an organization's computer systems and data from unauthorized access, use, disclosure, disruption, modification, or destruction. Taking this course may be useful for Information Security Analysts who want to gain a deeper understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Information Security Analyst
Software Engineer
Software Engineers design, develop, and maintain software applications. They use programming languages to create and manage software, ensuring it is properly configured and troubleshooting any issues. Taking this course may be useful for Software Engineers who want to gain a deeper understanding of database mirroring. This course covers the basics of database mirroring, its capabilities, and its limitations. It also explores how to prepare an environment for database mirroring and how to configure database mirroring using either SQL Server Management Studio or T-SQL scripts.
See salaries and explore the career path for Software Engineer

Reading list

We've selected eight 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 SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring.
Cover image
Microsoft SQL Server 2017 on Linux
Save
Provides a comprehensive overview of database recovery in SQL Server, including database mirroring. It valuable resource for anyone who wants to learn more about how to recover their databases in the event of a failure.
Microsoft SQL Server 2017 on Linux
Paperback
Check
Microsoft SQL Server 2017 on Linux
Kindle Edition
Check
Cover image
SQL Server MVP Deep Dives, Volume 2
Save
Provides a comprehensive overview of high availability in SQL Server, including database mirroring. It valuable resource for anyone who wants to learn more about how to keep their databases available.
SQL Server MVP Deep Dives, Volume 2
Kindle Edition
$$
Cover image
Subsystem and Transaction Monitoring and Tuning...
Save
Provides a comprehensive overview of high availability and disaster recovery in DB2 11 for z/OS, including database mirroring. It valuable resource for anyone who wants to learn more about how to keep their DB2 databases available.
Subsystem and Transaction Monitoring and Tuning...
Paperback
$$$
Cover image
High Performance MySQL
Save
Provides a comprehensive overview of high availability in MySQL, including database mirroring. It valuable resource for anyone who wants to learn more about how to keep their MySQL databases available.
High Performance MySQL: Optimization, Backups, and...
Paperback
$$
High Performance MySQL: Optimization, Backups,...
Paperback
$$
(中文) High Performance MySQL ( 3rd Edition ) (MySQL...
Paperback
$$
Cover image
SQL Server 2017 Administrator's Guide
Save
Provides a practical guide to configuring and managing database mirroring in SQL Server, covering topics such as setting up a database mirroring environment, monitoring database mirroring, and troubleshooting database mirroring.
SQL Server 2017 Administrator's Guide: One stop...
Kindle Edition
$$
Cover image
SQL Server T-SQL Recipes
Save
Provides a collection of recipes for configuring and managing database mirroring in SQL Server, covering topics such as setting up a database mirroring environment, monitoring database mirroring, and troubleshooting database mirroring.
SQL Server T-SQL Recipes
Kindle Edition
$$
SQL Server 2012 T-SQL Recipes: A Problem-Solution...
Paperback
$$$
Cover image
SQL Server 2017 Administrator's Guide
Save
Provides a comprehensive guide to database mirroring in SQL Server, covering topics such as the benefits of database mirroring, how database mirroring works, and how to configure and manage database mirroring.
SQL Server 2017 Administrator's Guide: One stop...
Kindle Edition
$$
Cover image
Oracle Data Guard 11g Handbook
Save
Provides a comprehensive guide to database mirroring in SQL Server, covering topics such as the benefits of database mirroring, how database mirroring works, and how to configure and manage database mirroring.
Oracle Data Guard 11g Handbook (Oracle Press)
Paperback
$$
Oracle Data Guard 11g Handbook (Oracle Press)
Kindle Edition
$$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring.
SQL Server: Understanding, Configuring, and...
Most relevant
SQL Server Administration Part 3
Most relevant
SQL Server: Installing and Configuring SQL Server 2016
Most relevant
Advanced SQL Server Triggers: Optimizing and...
Most relevant
SQL Server: Upgrading and Migrating to SQL Server 2016
Most relevant
Introduction to SQL Server
Most relevant
Configuring Net Services with Oracle
Most relevant
Troubleshooting SQL Server Performance with sp_WhoIsActive
Most relevant
Getting Started with Your First SQL Server Instance
Most relevant
Course image
Time
151 hours
Level
Intermediate
Via
Pluralsight
Instructor
Glenn Berry
Language
English
Good to know
Strengthens an existing foudnation for intermediate learners in database mirroring
Core skills for DBAs, developers, and system administrators who want to gain a deeper understanding of database mirroring
Covers unique perspectives in the area of database mirroring
Multi-modal with videos and discussions
Taught by Glenn Berry, an established instructor in the field of database mirroring
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
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