Log Shipping

So You Want a Cheap Disaster Plan

Last Updated November 22, 2017

There’s a lot that goes into a Disaster Recovery plan. One of them is offsite backups. There are some businesses that don’t have backups going offsite, let alone a Disaster Recovery plan. This conversation has taken place more than I thought it would. Me: Do you have any HA or DR features in place? Them:…

sp_AllNightLog: Creating Jobs Like I’m The President

Last Updated August 11, 2017

Erik Darling

Backup and Recovery, Clients and Case Studies, ISV and SaaS Database Design, kCura Relativity, Log Shipping, SQL Server

Look, we need these things The setup for sp_AllNightLog creates jobs for four separate activities 1 job to poll for new databases to back up (primary) 1 job to poll for new databases to restore (secondary) 10 jobs to poll for backups to take (primary) 10 jobs to poll for restores to… whatever (secondary) And,…

sp_AllNightLog: Poll Vaulting

Last Updated July 12, 2017

Erik Darling

Backup and Recovery, Clients and Case Studies, ISV and SaaS Database Design, kCura Relativity, Log Shipping, SQL Server

Carry on It turns out that the only thing harder than checking for new databases restored to a SQL Server, is checking a folder for a backup of a database that doesn’t exist on another SQL Server. These are both part of what sp_AllNightLog has to do. The other components, which use workers and a…

New White Paper: How to Build a SQL Server Disaster Recovery Plan with Google Compute Engine

Last Updated March 17, 2017

Tara Kizer

Google Compute Engine, High Availability, Log Shipping, Processes and Practices

You’re a systems administrator or database administrator who wants to protect your production SQL Server. However, you don’t have a separate data center or another colo site. Learn about what we call Log Shipping 2.0 You’re looking for instructions on: How to copy your SQL Server databases to Google Cloud Storage How to spin up…

The Cost of Adding a Reporting Server

Last Updated February 13, 2017

Brent Ozar

Architecture, Licensing, Log Shipping, SQL Server

“We’d like to offload our reporting queries to a separate SQL Server.” The first costs are fairly obvious. Hardware and storage – even if you’re running it in a virtual machine, you need to account for the costs of say, 4 cores and 32GB RAM. Not only will you need storage for the databases, but…

How to Run DBCC CHECKDB on a Log Shipping Subscriber

Last Updated February 13, 2017

Brent Ozar

Backup and Recovery, CHECKDB and Corruption, Log Shipping, SQL Server

At first glance, if you set up log shipping the way most folks do, it looks like you can’t run CHECKDB on a subscriber: Database cannot be opened. It is in the middle of a restore. Please close the bathroom door. On SQL Server Enterprise Edition, you can try working around it by creating a…

Comparing SQL Server and Oracle Log Shipping

Last Updated February 13, 2017

Jeremiah Peschka

Log Shipping, Oracle, SQL Server

Both Oracle and SQL Server offer several ways to support disaster recovery scenarios. One of the simplest ways to handle DR in the SQL Server world is to use SQL Server log shipping. Oracle doesn’t offer log shipping as a part of the core product, but it’s possible to set up log shipping in Oracle.…

Reporting From a Log Shipping Secondary in STANDBY mode

Last Updated February 13, 2017

Kendra Little

Log Shipping, SQL Server

You can build a lot with simple tools. Carefully. I’m a fan of SQL Server’s transaction log shipping. It works in Standard Edition, it’s relatively simple to set up, and you can even make your log shipping secondary readable using STANDBY mode. I’ve worked with some pretty cool, complex log shipping environments over the years.…

Log Shipping Magic: Using A Differential Backup to Refresh a Delayed Secondary

Last Updated February 13, 2017

Kendra Little

Log Shipping, SQL Server

Log: It’s better than bad, it’s good! Let’s say you’re a DBA managing a 2TB database. You use SQL Server transaction log shipping to keep a standby copy of the database nice and warm in case of emergency. Lots of data can change in your log shipping primary database: sometimes it’s index maintenance, sometimes it’s…

Log Shipping FAQ

Last Updated March 18, 2017

Jes Schultz

Log Shipping, SQL Server

390

I’ve been working with and talking about SQL Server Log Shipping a lot lately! One way to ship logs… I’ve gotten a lot of great questions about log shipping, so I’ve put together an FAQ. What editions of SQL Server is log shipping available in? 2012 – Enterprise, Business Intelligence, Standard, and Web 2008R2 –…

The Cost of Log Shipping SQL Server to Amazon S3

Last Updated February 13, 2017

Brent Ozar

Log Shipping, SQL Server

Want to know how much it’ll cost to back up your database transaction logs to Amazon S3? I’ll show you with a snippet of T-SQL. Note the parameters at the top for retention periods. The defaults assume one full backup weekly. DBAs would normally want to do full backups more often, but when you’re paying…