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