O'Reilly logo

Microsoft® SQL Server™ 2000 High Availability by Frank McBath, Kimberly Tripp, Cathan Cook, Allan Hirt

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required