Restoring SQL Server 2000 Databases
Video References
These additional references will help you take what you've learned in this SQL Server Video to the next step.
Book References
SQL Server 2000 Administrator's Pocket Consultant
Relevance: Chapter 11 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: The entry for the RESTORE statement in Books Online (for SQL Server 2000) provides some great insight into flexibility - and also provides some examples of different kinds of RESTORE operations.
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.
