Chapter 10. Implementing Backup and Restore

Chapter 9, provided the foundation to help you prepare your backup and restore strategy. This chapter guides you through that process.

Creating an Effective Backup Strategy

On many production servers, the backup and restore strategy is to perform only periodic (such as weekly) full database backups with transaction log backups between the full database backups (with a frequency of, say, every two hours). Some companies add occasional differential database backups (for example, nightly except on the day when full backups occur). The basic strategy of performing full database backups and transaction log backups is adequate to minimize data loss.

However, if you want to achieve high availability, you can minimize ...

Get Microsoft® SQL Server™ 2000 High Availability 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.