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.