New Database Administration Features
SQL Server 2008 introduced backup compression for Enterprise Edition. With SQL Server 2008 R2, backup compression is supported in Standard and all higher editions (every edition of SQL Server 2008 and later can restore a compressed backup, however). In addition to the space savings provided by compressed backups, compressing a backup also typically increases backup speed because it requires less device I/O. However, the I/O cost savings comes at the expense of increased CPU usage caused by the compression process. For more information on compressing backups, see Chapter 14, “Database Backup and Restore.”
Policy-Based Management is a new mechanism in SQL Server 2008 for managing one or more instances of SQL ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
