SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring
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.
What you'll learn
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.
Table of contents
- Introduction and Selecting Servers for Database Mirroring 3m
- Configuring Instance-level Settings and Security 4m
- Demo: Configuring Instance-level Settings 5m
- Preparing the Principal Instance 2m
- Tuning Backup and Restore Performance 3m
- Demo: Tuning Backup and Restore Performance 3m
- Preparing the Mirror Instance 2m
- Preparing the Witness Instance and Module Summary 2m
- Introduction 2m
- Database Mirroring Requirements and Restrictions 3m
- Database Mirroring Tips and Tricks 5m
- Preparing the Mirror Database 2m
- Demo: Preparing the Mirror Database 2m
- Configuration Using the Database Mirroring Security Wizard 1m
- Demo: Configuration Using the Database Mirroring Security Wizard 2m
- Configuration Using T-SQL 1m
- Demo: Configuration Using T-SQL 7m
- Module Summary 1m
- Introduction 1m
- Database Mirroring Monitor and Mirroring Queues 3m
- Demo: Database Mirroring Monitor 2m
- Database Mirroring Monitor Stored Procedures and Metadata 2m
- Demo: Database Mirroring Monitor Stored Procedures 4m
- Demo: Database Mirroring Metadata 3m
- Database Mirroring Performance Counters and Event Notifications 2m
- Demo: Database Mirroring Performance Counters 1m
- Demo: Database Mirroring Event Notifications 9m
- Database Mirroring Failovers 1m
- Demo: Database Mirroring Failovers 8m
- Common Database Mirroring Problems 3m
- Demo: Common Mirroring Problems 7m
- Database Mirroring Troubleshooting Tips 1m
- Demo: Database Mirroring Troubleshooting Tips 4m
- Module Summary 1m
- Introduction and Advantages Over Other Methods 3m
- Migration Considerations and Moving Data with Database Mirroring 3m
- Demo: Moving Data with Database Mirroring 3m
- Migrating/Upgrading with Database Mirroring and Post-migration Tasks 1m
- Demo: Migrating/Upgrading with Database Mirroring 3m
- Post Migration Tasks 1m
- Demo: Post Migration Tasks 3m
- Module and Course Summaries 2m
About the author
Glenn works as a Principal Consultant at SQLskills.com. He has been a SQL Server MVP since 2007, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, and performance tuning. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher P... more