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
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
