Search Results for “disaster recovery”

Backups Gone Bad: The Danger of Differentials

Last Updated February 13, 2017

As your databases get bigger, you’re going to run out of time to do nightly full backups. You’re going to be tempted by the siren song of differential backups. The idea is that you’ll do full backups on the weekends, and then differential backups each night of the week. Differential backups aren’t just the sum…

Microsoft SQL Server 2012 Always On AGs at StackOverflow

Last Updated February 9, 2017

Brent Ozar

Always On Availability Groups, SQL Server, Stack Overflow

I recently finished helping the StackExchange team migrate their SQL Server 2008 infrastructure to SQL Server 2012. These servers power StackOverflow, DBA.StackExchange.com, the new AskPatents partnership with the US Patent and Trademark Office, and hundreds of other Q&A sites that together form one of the biggest web site networks. It’s one of the most visible…

Who’s taking your backups? No, really – who’s taking your backups?

Last Updated February 13, 2017

Jes Schultz

Backup and Recovery, SQL Server

Who in your company is responsible for database backups? It’s Me Fantastic! Check your backup job. Did it run successfully the last time it was supposed to? Are the files where they are supposed to be? Have you checked the integrity of the backup files by restoring them to a secondary server? If you are…

ROOOOOXANNE...you don't have to put on your red light....

An Inside Look at Our PASS Summit Submissions

Last Updated February 12, 2017

Brent Ozar

#SQLPass

The Professional Association for SQL Server (PASS) holds a summit every year where thousands of database professionals gather to learn about the latest developments from Microsoft, meet their fellow community members, and drink Jägermeister. This year, there’s a new way to help shape the PASS Summit – you can vote on the sessions you’d like…

Why Are You Backing Up?

Last Updated February 13, 2017

Brent Ozar

Backup and Recovery

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…

Search Results for “disaster recovery”

Backups Gone Bad: The Danger of Differentials

Microsoft SQL Server 2012 Always On AGs at StackOverflow

Who’s taking your backups? No, really – who’s taking your backups?

An Inside Look at Our PASS Summit Submissions

Why Are You Backing Up?

Hi! I’m Brent Ozar.