We may earn an affiliate commission when you visit our partners.

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.

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.

Enroll now

Or start your subscription today

And complete this course over a free trial

What's inside

Syllabus

Course Overview

Introduction

Log Shipping Overview

Log Shipping Preparation Tasks

Configuring Log Shipping

Monitoring and Troubleshooting Log Shipping

Migrating Data Using Log Shipping

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops knowledge and skills related to database management and administration

Teaches technologies and techniques that are in line with industry best practices

Provides in-depth coverage of SQL Server log shipping, including its concepts, configurations, monitoring, and troubleshooting

Suitable for individuals with varied backgrounds in database management, including DBAs, developers, and system administrators

Instructed by Glenn Berry, a recognized expert in the field

Save this course

Save SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping to your list so you can find it easily later:

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 Log Shipping with these activities:

Create a study guide with notes and practice questions from the course

Show steps

Consolidate course materials for easy review and self-assessment

Browse courses on SQL Server

Show steps

Review course notes and materials
Identify key concepts and practice questions
Create a study guide

SQL Server Fundamentals

Show steps

Review the basics of SQL Server to strengthen your foundation before starting the course.

Browse courses on SQL Server

Show steps

Review database concepts such as tables, rows, and columns.
Practice writing simple SQL queries to retrieve and manipulate data.
Explore the SQL Server Management Studio interface and its basic functionality.

Review High-Performance MySQL

Show steps

Review an industry standard reference for SQL databases

View High Performance MySQL: Optimization, Backups,... on Amazon

Show steps

Read Chapter 1: Introduction
Read Chapter 2: Monitoring and Performance Tuning

Nine other activities

Expand to see all activities and additional details

Show all 12 activities

Follow a tutorial on troubleshooting common Log Shipping problems

Show steps

Supplement course material with additional troubleshooting guidance

Browse courses on Log Shipping

Show steps

Find a tutorial that covers common Log Shipping problems
Follow the steps in the tutorial

Log Shipping Implementation Tutorial

Show steps

Follow an online tutorial to set up and configure log shipping in a test environment.

Browse courses on Log Shipping

Show steps

Find a tutorial on log shipping implementation for SQL Server.
Follow the steps in the tutorial to create a log shipping configuration.
Monitor the log shipping process to ensure data is being replicated successfully.

Practice Log Shipping configuration using T-SQL scripts

Show steps

Gain proficiency in configuring Log Shipping using T-SQL

Browse courses on Log Shipping

Show steps

Create a database and log shipping configuration
Start and stop log shipping
Monitor log shipping status

Log Shipping Troubleshooting Exercises

Show steps

Practice troubleshooting common log shipping issues to improve your problem-solving skills.

Browse courses on Log Shipping

Show steps

Identify different types of log shipping errors.
Analyze error messages and understand their causes.
Apply problem-solving techniques to resolve log shipping issues.

Configure and troubleshoot Log Shipping for a database

Show steps

Apply the concepts learned in the course to a real-world scenario

Browse courses on Log Shipping

Show steps

Create a secondary database
Configure Log Shipping
Monitor Log Shipping
Troubleshoot common Log Shipping problems

Log Shipping Implementation Plan

Show steps

Create a detailed plan for implementing log shipping in a production environment.

Browse courses on Log Shipping

Show steps

Define the scope and objectives of the log shipping implementation.
Identify the source and destination databases for log shipping.
Configure the log shipping settings and monitoring mechanisms.
Develop a testing and validation plan for the log shipping implementation.

Write a blog post on the benefits and limitations of Log Shipping

Show steps

Reinforce understanding of Log Shipping by explaining it to others

Browse courses on Log Shipping

Show steps

Identify the benefits and limitations of Log Shipping
Write the blog post

Answer questions on a discussion forum related to Log Shipping

Show steps

Reinforce knowledge by sharing it with others and clarifying concepts

Browse courses on Log Shipping

Show steps

Find a discussion forum where people ask questions about Log Shipping
Monitor the forum for questions related to Log Shipping
Answer questions as you are able

Create a presentation on Log Shipping for a team meeting

Show steps

Communicate knowledge of Log Shipping to others and address potential questions

Browse courses on Log Shipping

Show steps

Identify the key concepts of Log Shipping
Create slides that explain the benefits and limitations of Log Shipping
Prepare to answer questions about Log Shipping

Career center

Learners who complete SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator configures, maintains, and repairs databases. They ensure that data is securely stored, organized, and backed up. This course may be useful in a career as a Database Administrator by providing a foundation in log shipping, which is a technique used for high availability and disaster recovery. This course provides practical guidance on configuring and troubleshooting log shipping in SQL Server, which can be valuable knowledge for a Database Administrator who needs to ensure the reliability and performance of database systems.

See salaries and explore the career path for Database Administrator

Data Analyst

A Data Analyst collects, analyzes, and interprets data to identify trends and patterns. They use this information to make recommendations and solve problems. This course may be useful in a career as a Data Analyst by providing a foundation in log shipping, which can be used to transport data between databases. This course covers how to prepare an environment for log shipping, configure log shipping, and troubleshoot common problems, which can be valuable knowledge for a Data Analyst who needs to manage and analyze data.

See salaries and explore the career path for Data Analyst

Data Architect

A Data Architect designs and implements data management solutions. They work with business stakeholders to understand data needs and develop data models. This course may be useful in a career as a Data Architect by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Data Architect who needs to design and implement high availability and disaster recovery solutions.

See salaries and explore the career path for Data Architect

Software Engineer

A Software Engineer designs, develops, and maintains software applications. They work with users to understand requirements and develop solutions. This course may be useful in a career as a Software Engineer by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a Software Engineer who needs to develop and maintain database applications.

See salaries and explore the career path for Software Engineer

Business Analyst

A Business Analyst gathers and analyzes business requirements. They work with stakeholders to understand needs and develop solutions. This course may be useful in a career as a Business Analyst by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Business Analyst who needs to understand data management and disaster recovery solutions.

See salaries and explore the career path for Business Analyst

IT Manager

An IT Manager plans and manages the IT infrastructure of an organization. They work with users to understand needs and develop solutions. This course may be useful in a career as an IT Manager by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for an IT Manager who needs to understand data management and disaster recovery solutions.

See salaries and explore the career path for IT Manager

Cloud Architect

A Cloud Architect designs and implements cloud computing solutions. They work with users to understand needs and develop solutions. This course may be useful in a career as a Cloud Architect by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Cloud Architect who needs to design and implement high availability and disaster recovery solutions.

See salaries and explore the career path for Cloud Architect

Database Developer

A Database Developer designs and develops database applications. They work with users to understand requirements and develop solutions. This course may be useful in a career as a Database Developer by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a Database Developer who needs to develop and maintain database applications.

See salaries and explore the career path for Database Developer

System Administrator

A System Administrator manages the computer systems of an organization. They work with users to understand needs and develop solutions. This course may be useful in a career as a System Administrator by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a System Administrator who needs to manage and maintain database systems.

See salaries and explore the career path for System Administrator

Database Engineer

A Database Engineer designs and develops database systems. They work with users to understand needs and develop solutions. This course may be useful in a career as a Database Engineer by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a Database Engineer who needs to develop and maintain database systems.

See salaries and explore the career path for Database Engineer

Network Administrator

A Network Administrator manages the computer networks of an organization. They work with users to understand needs and develop solutions. This course may be useful in a career as a Network Administrator by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Network Administrator who needs to understand data management and disaster recovery solutions.

See salaries and explore the career path for Network Administrator

Information Security Analyst

An Information Security Analyst protects the computer systems of an organization from unauthorized access. They work with users to understand needs and develop solutions. This course may be useful in a career as an Information Security Analyst by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for an Information Security Analyst who needs to understand data management and disaster recovery solutions.

See salaries and explore the career path for Information Security Analyst

Computer Systems Analyst

A Computer Systems Analyst analyzes and evaluates computer systems. They work with users to understand needs and develop solutions. This course may be useful in a career as a Computer Systems Analyst by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers how to configure and troubleshoot log shipping, which can be valuable knowledge for a Computer Systems Analyst who needs to manage and maintain database systems.

See salaries and explore the career path for Computer Systems Analyst

Data Warehouse Architect

A Data Warehouse Architect designs and develops data warehouse systems. They work with users to understand needs and develop solutions. This course may be useful in a career as a Data Warehouse Architect by providing a foundation in log shipping, which is a technique used to replicate data between databases. This course covers the basics of log shipping, its capabilities, and its limitations, which can be valuable knowledge for a Data Warehouse Architect who needs to design and implement high availability and disaster recovery solutions.

See salaries and explore the career path for Data Warehouse Architect

Data Scientist

A Data Scientist collects, analyzes, and interprets data to identify trends and patterns. They use this information to make recommendations and solve problems. This course may be useful in a career as a Data Scientist by providing a foundation in log shipping, which can be used to transport data between databases. This course covers how to prepare an environment for log shipping, configure log shipping, and troubleshoot common problems, which can be valuable knowledge for a Data Scientist who needs to manage and analyze data.

See salaries and explore the career path for Data Scientist

Reading list

We've selected 14 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 Log Shipping.

Introducing Microsoft SQL Server 2016

Save

Covers a wide range of high availability and disaster recovery topics, including log shipping. It's a comprehensive resource for DBAs.

SQL Server

Understanding, Configuring, and Troubleshooting Log Shipping

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses