??? A tape holding a compressed backup cannot hold any other NTBackup files.
Even with these caveats, backup compression is a feature you??™ll want to consider taking
advantage of in order to use disk space (or tape) more efficiently.
nNote Encryption is a feature that is sometimes thought of as going hand in hand with compression.
SQL Server 2008 still doesn??™t provide encryption for a backup (just the same basic password protection),
so I see a lot of room for improvement here. Let??™s hope we see that improvement soon.
FILESTREAM Data
One of the more significant improvements in SQL Server 2008 is the ability to store
binary objects as files on the operating system, not within 8K data pages. Previous to SQL
Server 2008, all binary objects, such as Word documents and image files, had to be stored
APPENDIX n SQL SERVER 2008 CONSIDERATIONS 324
as either TEXT, NTEXT, IMAGE, VARCHAR(MAX), or VARBINARY(MAX). Each of these data types
organized information in terms of 8K pages, which led to a lot of wasted space. A 9K .jpg
file, for example, resulted in 16K minimum in terms of storage space used.
Pages:
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607