Chapter 7

SQL Server Backup and Recovery

Solutions in this chapter:

 Planning and Implementing a Successful Backup and Recovery Strategy

 Backup and Restore Tools and Techniques

 Backing Up SQL Server Databases

 Restoring SQL Server Databases

 Testing Your Backup and Recovery Strategy

Introduction

Backup and recovery procedures are essential to every organization, especially those employing central database systems. Recovering from system failure or user error can mean the difference between a business inconvenience and a profit loss! SQL Server 2000 offers several backup methods and media storage options that will allow you to implement a backup strategy that works within your organization.

Via support for snapshot backup and recovery options, performing ...

Get Designing SQL Server 2000 Databases 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.