Backup and Recovery

SAN Snapshot Smackdown

On Twitter, several SAN pros were saying their snapshots can pull off some nifty stuff.  Well, it’s time to find out just how true that is. Let’s say we have a data warehouse with: One 2TB database, using SQL Server partitioning – needs 8 data files and 1 log file One 200GB database for reporting…
Read More

Why Are You Backing Up?

We focus so much on the fine-grained details of exactly when and where we’re backing up our servers.  Sometimes it helps to take a quick step back and ask what we’re trying to protect ourselves, because it’ll help us do a better job of designing a recovery strategy. Dude, Where's My Datacenter? From small problem…
Read More

How to BACKUP LOG WITH TRUNCATE_ONLY in SQL Server 2008, R2, 2012, 2014, 2016, 2017, 2019

BACKUP LOG WITH TRUNCATE_ONLY is a dangerous command: it empties out the contents of your SQL Server’s transaction log without really backing it up.  Database administrators sometimes run this command right before shrinking their log file with a DBCC SHRINKFILE command, thereby freeing up drive space. Why ‘truncate_only’ is not a recognized backup option. When…
Read More

Another backup failure: Carbonite

TechCrunch reports that Carbonite, an online backup company, lost customer data. But wait, this is different: it’s not their fault.  They’re suing Promise Technology, makers of popular storage gear, for selling them bogus equipment.  Bogus equipment?  You mean, like hard drives that fail?  That’s horrible!  Who could expect something like that?  Who could know about…
Read More

Backup Fail: Ma.gnolia goes under

Bookmark sharing site Ma.gnolia just had a big problem (not quite clear from the site what it was) and user data was trashed.  They needed to restore from backup. Only one little problem – they didn’t have one. And now they’re out of business. We’ve talked about this before when JournalSpace failed, and I’m sure…
Read More

Mirrors aren’t backups

Are you using any of these technologies as a method of database protection? Database mirroring (keeping two database servers synchronized with the same data via SQL 2005/2008) Replication (copying records between databases) Log shipping (copying log files to another server and restoring them immediately) SAN-based mirroring (storing two copies of your database on two different…
Read More

Microsoft DPM 2007 review

I spent some time last week digging into Microsoft Data Protection Manager 2007, Microsoft’s solution for SQL Server backups, and I’m going to share some of my findings here with you, dear reader. “But You Work For Quest Software! You can’t write a Microsoft DPM review!” Yeah, disclaimer time – I work for the people…
Read More