- Course
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.
- Course
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.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.