SQL Server with Mr. Denny:

Log Shipping


January 29, 2014  2:00 PM

Log Shipping Databases and Permissions Problems

Posted by: Denny Cherry
Attaching Database, Data Security, Database, Database Administration, Error 3013, Error 3119, Error 4319, Full Recovery Model, Log Shipping, Recovery Model, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Recently I was doing log shipping for a client in preparation to move their databases from one data center to another, when I was asked to change the drive that one of the target databases was being restored to. No problem, I'll just use ALTER DATABASE ... MODIFY FILE (name='xxx',...

May 28, 2012  2:00 PM

Figuring out how log shipping is doing

Posted by: Denny Cherry
Backup & recovery, Log Shipping, Migration, Restore Database, SQL Server

A lot of the time when doing data center migrations or system migrations I end up using Transaction Log Shipping to get the data from one SQL Server to another.  I do this for a few reasons.

  1. It's reliable.
  2. It's easy to do (I've got plenty of scripts sitting around to...

December 20, 2010  2:00 PM

Database Restores and Torn Pages

Posted by: Denny Cherry
Log Shipping, SQL Server, Storage

This weekend I was migrating some databases from one server to another.  As these were rather large databases (about 2 TB in size) and I didn't have the clusters setup on a SAN (using DAS instead) I needed to setup log shipping from one cluster to another so that the downtime when moving was kept...

September 2, 2008  7:30 PM

Get SQL Server log shipping functionality without Enterprise Edition

Posted by: Denny Cherry
Article, Log Shipping, SQL Server 2000, SQL Server 2005, SQL Server 2008

A new tip of mine has just been published on SearchSQLServer.com.  This tip, "Get SQL Server log shipping functionality...

Bookmark and Share     0 Comments     RSS Feed     Email a friend

August 25, 2008  11:00 AM

How to setup a server to read log files nightly.

Posted by: Denny Cherry
Backup & recovery, KILL, Log Shipping, Recovery, RESTORE LOG, SQL Server 2005, xp_delete_file, xp_dirtree

So you've been tasked with setting up a quick and dirty reporting server.  The goal is to restore the log files from the production server to the reporting server nightly.  The backups are simple, use the SQL Maintenance plan to backup the logs, and then copy them to the remote machine.  But...

January 14, 2008  8:00 AM

Log Shipping without SQL Server Enterprise Edition

Posted by: Denny Cherry
DR, Log Shipping, Replication, SQL, T/SQL

Microsoft's Log Shipping is pretty good.  But it requires that you have SQL Server Enterprise Edition on both the machines.  This makes the solution fairly expensive.  Because of this I've written a replacement which can be used on any edition of SQL Server including SQL Server Express Edition...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: