SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping
Learn how to correctly configure and use SQL Server log shipping, 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 log shipping is a very useful technology for high availability and disaster recovery, as well for general purpose database movement, migration, and upgrades. In this course, SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping, you'll first learn the basics of log shipping, its capabilities, and its limitations. Next, you'll learn how to prepare an environment for log shipping, and then how to configure log shipping, using either SQL Server Management Studio or T-SQL scripts. You'll learn how to monitor a log shipping environment and troubleshoot common problems, and finally you'll learn how to use log shipping 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 log shipping.
Table of contents
- Introduction and Selecting Log Shipping Servers 1m
- Configure Instance-level Settings 1m
- Demo: Check Instance-level Settings 5m
- Configuring Security 2m
- Demo: Backup Directory Share Security 1m
- Preparing the Primary Instance and Backup Compression 2m
- Preparing the Other Instances and Module Summary 3m
- Introduction, Monitoring Prerequisites, and the Status Report 2m
- Demo: Log Shipping Status Report 1m
- Error Log Messages and Log Shipping History Tables 2m
- Demo: Reading the SQL Server Error Log 2m
- Demo: Querying Log Shipping History Tables 5m
- Stored Procedures for Monitoring 1m
- Demo: Running Monitoring Stored Procedures 6m
- Common Problems 3m
- Demo: Troubleshooting Secondary Instance Issues 3m
- Demo: Troubleshooting SQL Agent Job Failures 3m
- Module Summary 1m
- Introduction and Using Log Shipping for Migration 2m
- Migration Considerations and Moving Data with Log Shipping 2m
- Demo: Moving Data with Log Shipping 4m
- Migrating/Upgrading and Post-migration Tasks 2m
- Demo: Migrating/Upgrading with Log Shipping 4m
- Demo: Post-migration Tasks 3m
- Module and Course Summary 1m
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