Restoring Databases with SQL Server Management Studio
Video References
These additional references will help you take what you've learned in this SQL Server Video to the next step.
Book References
Microsoft SQL Server 2005 Administrator's Pocket Consultant
Relevance: Chapter 14 provides some great information on a number of different restoration scenarios that you can use. And, after watching this video, will serve as a great reference tool that can help you create your own disaster recovery plan and documentation.
Links / References
SQL Server Books Online [link]
Relevance: Books Online (for SQL Server 2005 and 2008) contains some great samples and examples of different types of scenarios that you might
encounter when performing RESTORE operations. I highly recommend reviewing and working through them if you need additional insight
and experience.
SQL Server 2005
SQL Server 2008
SQL Server Books Online [link]
Relevance: Routinely backing up the MSDB database (i.e. log file backups every 15 minutes or so) can help make recovery from a disaster
much easier - as demonstrated in this video. However, the MSDB database isn't set to Full Recovery Mode by default, and even
if you manually set it to FULL (or Bulk Logged) Recovery, there are a few activities that can 'trigger' it to return
to SIMPLE Recovery.
This entry in Books Online helps
discuss those actions, or triggers.
