Log Shipping

Logshipping Report

Get Logshipping report only when secondary is more than certain time behind Primary.

Step By Step SQL Server Log Shipping

Jugal Shah walks through the steps of setting up Log Shipping.

Move an Existing Log Shipping Database to a New Monitor Server

How to move a log shipping database to a new monitor server without removing and rebuilding the log shipping setup.

Faster Log Shipping Restores

When you’re reading from a log shipped secondary, you want the duration of restores to be as short as possible. The sproc provided switches the restores to “NORECOVERY” mode, and then switch back to “STANDBY” at the end of the process.

Streamline Log Shipping Failovers: DR Made Just For You…

A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.

Temporarily Change SQL Server Log Shipping Database to Read Only

I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I don't want to reconfigure Log Shipping, so is there a way to do this without redoing Log Shipping.

Fix SQL Server Log Shipping After a New Database File has been Added

The code in this tip will demonstrate how to continue SQL Server Log Shipping after a file has been added to the primary SQL Server database.

Helping Streamline Log Shipping Failovers

Using Log Shipping? Looking for a more automated way to fail over during a disaster? Read on...

Steps to rollback database changes without impacting SQL Server Log Shipping

When pushing a major release to a large production database, you want to know that you'll be able to rollback changes if the need arises. These are some simple steps which we can follow to ensure that we don't have to reconfigure log shipping all over again thereby saving time and ensuring systems are not affected when rolling back changes.