TechNet Magazine: feature article on recovering from disasters using backups

The November 2009 edition of TechNet Magazine is up on the web and contains my latest feature article, the second in a 3-part series on backups/restores/repairs.

In this article I explain all about using the RESTORE command. Not much point having backups if you don't know how to use them! Topics include:

  • The four phases of a restore operation – how they work and how you can speed them up
  • Figuring out what you need to restore when a disaster happens
  • Figuring out what you're actually able to restore
  • Using WITH RECOVERY / NORECOVERY / STANDBY
  • Point-in-time restore operations
  • Considerations when restoring to a different location

There seem to be a few formatting issues when the magazine's web folks put the article up – I've notified them and hopefully they'll fix them soon.

You can get to the article at: http://technet.microsoft.com/en-us/magazine/ee677581.aspx

Enjoy!

Busy week coming up at the 2009 PASS Summit

It's PASS time again in Seattle and we've got a busy week lined up. It's going to be a cavalcade of meeting new people, and in the best tradition of conferences past, I'll do my best to remember most people's names who I met last year but please don't be offended if I don't, give me a prod in the right direction :-) Best bet for having me remember is to have something brightly colored on show: Jason has vivid red hair, Denny has partly bright blue hair, Brent has big green fists, and Thomas has off-color blog posts. My brightly-colored attire will include a tall blonde woman next to me most of the time.

Here's what we have definitely on the schedule so far:

  • Our pre-con workshop on Monday
  • Playing in the welcome reception Quiz Bowl Monday night
  • Birds of a Feather lunch on Tuesday. I'm doing "Chow Down on Corruption" and Kimberly's doing "Kimberly Tripp Covers Indexes (and Lunch)". Our tables are going to be next to each other so that we can heckle. My table will at least have to make it known that our table title is cleverer than hers.
  • My Wednesday morning Spotlight session on Understanding Logging and Recovery
  • Kimberly's Wednesday afternoon Spotlight session on Covering Indexes
  • Our post-con workshop on Friday

And some parties and other frivolity thrown in.

Hope to see you there!

PS Seems like #sqlpass is the Twitter tag for the conference, prepare to be overwhelmed!

PPS If you're speaking for the first time at PASS, checkout my long Valentine's Day blog post about how to present: Public Speaking: A Primer