SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring

SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 2h 31m | 428 MB

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.

Table of Contents

01 – Course Overview
02 – Introduction and What Is Database Mirroring
03 – Benefits of Database Mirroring
04 – Course Objectives
05 – Course Structure and Module Summary
06 – Introduction and Database Mirroring Operations
07 – Database Mirroring Configurations
08 – High Availability Capabilities and Limitations
09 – Disaster Recovery Capabilities and Limitations
10 – Reporting Capabilities and Limitations
11 – Module Summary
12 – Introduction and Selecting Servers for Database Mirroring
13 – Configuring Instance-level Settings and Security
14 – Demo – Configuring Instance-level Settings
15 – Preparing the Principal Instance
16 – Tuning Backup and Restore Performance
17 – Demo – Tuning Backup and Restore Performance
18 – Preparing the Mirror Instance
19 – Preparing the Witness Instance and Module Summary
20 – Introduction
21 – Database Mirroring Requirements and Restrictions
22 – Database Mirroring Tips and Tricks
23 – Preparing the Mirror Database
24 – Demo – Preparing the Mirror Database
25 – Configuration Using the Database Mirroring Security Wizard
26 – Demo – Configuration Using the Database Mirroring Security Wizard
27 – Configuration Using T-SQL
28 – Demo – Configuration Using T-SQL
29 – Module Summary
30 – Introduction
31 – Database Mirroring Monitor and Mirroring Queues
32 – Demo – Database Mirroring Monitor
33 – Database Mirroring Monitor Stored Procedures and Metadata
34 – Demo – Database Mirroring Monitor Stored Procedures
35 – Demo – Database Mirroring Metadata
36 – Database Mirroring Performance Counters and Event Notifications
37 – Demo – Database Mirroring Performance Counters
38 – Demo – Database Mirroring Event Notifications
39 – Database Mirroring Failovers
40 – Demo – Database Mirroring Failovers
41 – Common Database Mirroring Problems
42 – Demo – Common Mirroring Problems
43 – Database Mirroring Troubleshooting Tips
44 – Demo – Database Mirroring Troubleshooting Tips
45 – Module Summary
46 – Introduction and Advantages Over Other Methods
47 – Migration Considerations and Moving Data with Database Mirroring
48 – Demo – Moving Data with Database Mirroring
49 – Migrating_Upgrading with Database Mirroring and Post-migration Tasks
50 – Demo – Migrating_Upgrading with Database Mirroring
51 – Post Migration Tasks
52 – Demo – Post Migration Tasks
53 – Module and Course Summaries