We may earn an affiliate commission when you visit our partners.
SQL Server
Understanding, Configuring and Troubleshooting Database Mirroring
Glenn Berry
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.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/6ea1gy/sql
What's inside
Syllabus
Course Overview
Introduction
Database Mirroring Overview
Preparing for Database Mirroring
Read more
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
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
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Organize and review course materials for better retention
Show steps
Enhance your understanding by organizing and reviewing course materials to solidify your knowledge and improve recall.
Show steps
Show steps
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
Show steps
Refresh your knowledge of database mirroring before starting the course.
Browse courses on
Database Mirroring
Show steps
Show steps
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
Show steps
Refresh your knowledge of database mirroring concepts and its role in ensuring data availability and business continuity.
Browse courses on
Database Mirroring
Show steps
Show steps
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
Show steps
Review the fundamental concepts of database systems to strengthen your understanding of database mirroring.
Show steps
Show steps
Show steps
- Read Chapters 1-5
- Complete the practice exercises at the end of each chapter
Join a Database Mirroring Study Group
Show steps
Engage with peers to discuss and reinforce database mirroring concepts.
Browse courses on
Database Mirroring
Show steps
Show steps
Show steps
- Find a study group or online forum
- Participate in discussions, ask questions, and share your knowledge
Follow Microsoft's Database Mirroring Tutorials
Show steps
Supplement your learning by following Microsoft's official tutorials on database mirroring.
Browse courses on
Database Mirroring
Show steps
Show steps
Show steps
- Visit Microsoft's documentation website
- Follow the step-by-step tutorials
SQL Server Database Mirroring Practice Exercises
Show steps
Complete practice exercises to solidify your understanding of database mirroring concepts and configuration.
Browse courses on
Database Mirroring
Show steps
Show steps
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
Show steps
Participate in a workshop to gain hands-on experience and expert guidance on database mirroring.
Browse courses on
Database Mirroring
Show steps
Show steps
Show steps
- Find a relevant workshop
- Register and attend the workshop
- Actively participate and ask questions
Configure database mirroring using T-SQL scripts
Show steps
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
Show steps
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
Show steps
Enhance your understanding by creating a visual representation of a database mirroring setup.
Browse courses on
Database Mirroring
Show steps
Show steps
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
Show steps
Apply your knowledge by migrating a database to a new server using database mirroring.
Browse courses on
Database Mirroring
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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 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.
Database Administrator Analyst
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.
Database Developer
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.
Database Administrator
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.
Database Administrator Manager
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.
Data Architect
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.
Computer Systems Analyst
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.
Systems Administrator
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.
Cloud Engineer
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.
Data Analyst
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.
Business Intelligence 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.
Data Scientist
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.
Software Development Manager
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.
Information Security Analyst
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.
Software Engineer
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.
For more career information including salaries, visit:
OpenCourser.com/course/6ea1gy/sql
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.
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.
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.
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.
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.
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.
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.
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.
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/6ea1gy/sql
Share
Similar courses
Here are nine courses similar to
SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring.
SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping
OpenCourser.com/course/173zi9/sql
SQL Server: Understanding, Configuring, and...
Most relevant
SQL Server Administration Part 3
OpenCourser.com/course/ser9ir/sql
SQL Server Administration Part 3
Most relevant
SQL Server: Installing and Configuring SQL Server 2016
OpenCourser.com/course/pz05gx/sql
SQL Server: Installing and Configuring SQL Server 2016
Most relevant
Advanced SQL Server Triggers: Optimizing and Troubleshooting
OpenCourser.com/course/9fh1d0/advanced
Advanced SQL Server Triggers: Optimizing and...
Most relevant
SQL Server: Upgrading and Migrating to SQL Server 2016
OpenCourser.com/course/5hbceq/sql
SQL Server: Upgrading and Migrating to SQL Server 2016
Most relevant
Introduction to SQL Server
OpenCourser.com/course/fzah0i/introduction
Introduction to SQL Server
Most relevant
Configuring Net Services with Oracle
OpenCourser.com/course/m5g90b/configuring
Configuring Net Services with Oracle
Most relevant
Troubleshooting SQL Server Performance with sp_WhoIsActive
OpenCourser.com/course/wdw9pu/troubleshooting
Troubleshooting SQL Server Performance with sp_WhoIsActive
Most relevant
Getting Started with Your First SQL Server Instance
OpenCourser.com/course/i8cmc1/getting
Getting Started with Your First SQL Server Instance
Most relevant
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
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