O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

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

Implementing backup compression for a VLDB environment

VLDB /(Very Large Databases) have a specific requirement in terms of storage. The time required to backup increases, the method of backup is changed compared to normal databases and the recovery process is only a partial recovery process. Since SQL Server 2008, native backup compression was introduced for the Enterprise edition and SQL Server 2008 R2 has extended the feature to the Standard and Datacenter editions, for production purposes. The functionality allows the backup process to consume less disk space. The amount of compression gained depends on the data within the database. From the SQL Server 2008 Service Pack 2 onwards, every edition of SQL Server 2008 version and higher versions ...

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