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 can restore a compressed backup.

Filegroups are often used for very large databases for the ease of backup administration and to improve performance by distributing data files over disk LUNs. In order to provide a quicker recovery process for a VLDB...