Architecture Archives - Page 3 of 3 - Brent Ozar Unlimited®

Adding Reliability to Your Infrastructure

Last Updated June 24, 2017

I don’t wanna fly in a single-engine plane. Call me chicken, call me scaredy-cat, but I’m not excited to get into an airplane that will kill me if an engine fails. The next step up is a twin-engine plane – but I don’t get on all of those either. I like my engines to be…

Mirrors aren’t backups

Last Updated February 9, 2017

Brent Ozar

Architecture, Backup and Recovery, Database Mirroring

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…