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!

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.