O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

Full Recovery Model and Bulk Logged Recovery Model—Using Database Complete Backups and Transaction Log Backups to Restore a Database

The Full Recovery model and Bulk Logged Recovery model rely on using database backups in conjunction with transaction log backups to achieve up to the point of time recovery. It is important as a DBA to understand how to use database backups and transaction log backups to restore a database with up-to-the millisecond information. Let's walk through a database restore using the following example (see Figure 10.15).

Figure 10.15. An example of database and transaction log backups.

Using the example in Figure 10.15

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