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!