Skip to Main Content
Professional SQL Server High Availability and Disaster Recovery
book

Professional SQL Server High Availability and Disaster Recovery

by Ahmad Osama
January 2019
Intermediate to advanced content levelIntermediate to advanced
564 pages
9h 2m
English
Packt Publishing
Content preview from Professional SQL Server High Availability and Disaster Recovery

Lesson 6

Configuring and Managing Log Shipping

Learning Objectives

By the end of this lesson, you will be able to do the following:

  • Describe log shipping
  • Configure log shipping
  • Manage and monitor log shipping

This lesson will teach us how to configure log shipping. We will then see how to manage and troubleshoot it.

Introduction

Log shipping is one of the oldest disaster recovery solutions available in SQL Server. Log shipping automatically ships the transaction log backups of the specified database from a primary instance to one or more secondary instances. The secondary instances restore the transaction log backups individually, thereby maintaining a copy of the primary database.

In this lesson, we'll learn to configure, manage, and ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional SQL Server 2012 Internals and Troubleshooting

Professional SQL Server 2012 Internals and Troubleshooting

Christian Bolton, James Rowland-Jones, Glenn Berry, Justin Langford, Gavin Payne, Amit Banerjee

Publisher Resources

ISBN: 9781789802597Supplemental Content