Chapter 10. Backup and Recovery

by Mark Spenik and Orryn Sledge

IN THIS CHAPTER

  • SQL Server 2000 Backups—Simplified with Recovery Models (But Few Changes Under the Covers)

  • What Is a File/Filegroup Backup?

  • Creating a Backup Device

  • Performing Database, Transaction Log, Differential, and File/Filegroup Backups

  • Understanding Log Truncation Options

  • Backup Wizard

  • Using Multiple Backup Devices (Striped Backups) and Media Sets

  • Full Recovery Model and Bulk Logged Recovery Model—Using Database Complete Backups and Transaction Log Backups to Restore a Database

  • Performing a Database Restore

  • Restoring the master Database

  • Interactive Example of Losing and Restoring a Database

  • Creating a Backup Schedule

  • Backup and Restore FAQ

Backups are copies of SQL Server databases or ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.