No worries. The fundamental changes in most features have been
revealed by this point, and any that haven??™t been will be covered in an appendix available
on the Apress web site (www.apress.com).
nNote All information in this appendix is based on the November CTP.
Backup/Restore Improvements
The majority of the backup/restore features remain the same in SQL Server 2008. It still
features full, differential, and log backups; file and filegroup backups; piecemeal and
page-level restores; and so on. It still offers the same basic Full Recovery, Bulk-Logged
Recovery, and Simple Recovery modes. For the most part, Chapters 2, 3, and 4 still apply,
even syntactically.
However, there are some notable improvements to backup and recovery in SQL
Server 2008. These improvements make your job easier and enable you to protect your
database against loss and damage more efficiently. The subsections that follow describe
these new features.
321
A P P E N D I X
Tail-Log Backups
SQL Server 2005 was nice enough to warn you to back up the tail of the transaction log
(those transactions in between log backups) if you tried to overwrite an active database.
Pages:
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603