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.

Adding new files to a log-shipped database (SQL Spackle)

Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.

How to move a SQL Server Log Shipped Secondary Database to Different SQL Server

This tip I will explains a step-by-step method to perform the SQL Server Log Shipping migration.

Log Shipping - Monitor Server

Steps to add Log Shipping monitor into an existing SQL Server

I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a SQL Server 2005, 2008, 2008 R2 or 2012 environment without rebuilding the Log Shipping installation.

Logshipping Backup Files Management

Delete Log-shipping Tlog backup files which are already restored onto Secondary Server.