SQLServerCentral.com Articles tagged Log Shipping

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

Mon, 04 Mar 2013 07:00:00 UT

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

Steps to add Log Shipping monitor into an existing SQL Server

Wed, 05 Dec 2012 07:00:00 UT

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.

Repairing a Broken Log Shipping Plan From a Differential Backup

Thu, 27 Sep 2012 06:00:00 UT

This article details how to reinitialise a Log Shipping scenario from a primary differential backup

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Adding a log shipping monitor

Thu, 15 Mar 2012 06:00:00 UT

This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.

SQL Server Log Shipping Between Standalone\Workgroup Computers

Mon, 30 Jan 2012 07:00:00 UT

This article describes the requirements to log ship databases between workgroup computers

SQL Server Log Shipping to a Different Domain or Workgroup

Fri, 13 Jan 2012 07:00:00 UT

Sometimes the requirement arises to provide a copy of your database to an off-site location, such as a disaster recovery datacenter. Log Shipping is one of the most popular, proven technologies used to create a copy of your databases on a remote server.

How to Setup Log Shipping for Multiple Databases

Wed, 28 Sep 2011 06:00:00 UT

This article by Brian Davey describes how to setup log shipping for a large number of databases minimizing the number of jobs needed thus significantly reducing CPU and memory usage.

SQL Server Log Shipping For Large Databases

Fri, 23 Sep 2011 06:00:00 UT

In this article you will see the detailed steps needed to implement the log shipping for large databases.

Convert Mirroring to Log Shipping

Thu, 19 Aug 2010 06:00:00 UT

Describes how to convert database mirroring to log shipping in SQL 2005/2008.

Migrating VLDB with Log Shipping

Thu, 05 Aug 2010 06:00:00 UT

You just had a great weekend. You go grab your coffee and before you take a sip a manager grabs you and says, "we need your help." We need to migrate a very large database to our new data center. We need to keep the data in sync and have a short period of downtime when we cutover.

Log shipping and A Control Mechanism

Thu, 01 Jul 2010 06:00:00 UT

Longtime author Leo Peysakhovich has implemented a log shipping mechanism that can recover from failures and give you control over how it works. Read on if you want to implement your own version of log shipping and have control over all aspects of the process.

The Log Shipping Standard

Mon, 12 Apr 2010 06:00:00 UT

Log shipping is a tool that has more benefits than just recovering from a major disaster. Steve Jones thinks this might be a tool that DBAs should use for all their critical databases.

Configure disaster recovery across SharePoint farms by using SQL Server log shipping

Fri, 09 Oct 2009 06:00:00 UT

This article describes how to use Microsoft SQL Server 2005 or Microsoft SQL Server 2008 log shipping to create a disaster recovery farm in a geographically distributed data center for Microsoft Office SharePoint Server 2007 with Service Pack 2 (SP2). By using this configuration, you can provide a disaster recovery site that provides current search results when a failover occurs. The article assumes that you are familiar with the concepts and terms presented in Plan for availability (Office SharePoint Server).

Blog: Disabling Log Shipping When the Secondary Server Doesn't Exist

Thu, 22 Jan 2009 07:00:00 UT

Had a bit of an oddity show up during some testing today when trying to disable log shipping on the primary server using SSMS. My test scenario was such that our secondary server was not available any longer (had been renamed) and when I tried to disable the log shipping...

Log Shipping Cannot Access the File

Tue, 20 Jan 2009 07:00:00 UT

New author Brian Bitzer brings us a solution to a log shipping problem in the Real World. Read about jhow one DBA solves a contention issue using SSIS.

Sync All Logins on a Server in a single click using SP_MSForEachDB

Tue, 03 Jun 2008 06:00:00 UT

Reduce your recovery time and minimize the chance for error by resolving all logins in one script.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Custom Log Shipping

Thu, 01 May 2008 06:00:00 UT

This article presents a way to implement a simple database synchronization solution similar to log shipping using Database Maintenance Plans and T-SQL.

SQL Server 2005 log shipping setup using the wizard

Mon, 28 Apr 2008 06:00:00 UT

Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.

SQL Server 2005 log shipping setup using the wizard

Tue, 22 Apr 2008 06:00:00 UT

Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.