Microsoft® SQL Server™ 2000 Unleashed, Second Edition

Chapter 16. Database Backup and Restore

by Paul Jensen

IN THIS CHAPTER

• Developing a Backup and Restore Plan

• Why Back Up Your Databases?

• A Typical Backup and Restore Scenario

• Types of Backups

• Setting the Recovery Mode

• Backup Devices

• Media Sets and Families

• Creating Backup Devices with Transact-SQL

• Creating Backup Devices with SQL Enterprise Manager

• Backing Up the Database

• Backing Up the Transaction Log

• Restoring the Database

• Transact-SQL Restore Examples

• Restoring to a Different Database

• Restoring a File or Filegroup

• Restoring to a Point in Time

• Performing a Partial Database Restore

• Restoring the System Databases

• Additional Backup Considerations

One of most important tasks associated with database management is that of performing backups. A backup is a full or ...