Microsoft® SQL Server 2008 R2 Unleashed

Partial Backups

Partial backups are useful when read-only files or filegroups are part of a database. Listing 14.2 contains the commands necessary to add a read-only filegroup to the AdventureWorks2008 database. The commands in Listing 14.2 do not perform a partial backup, but they do modify a sample database so that a partial database would make sense.

Listing 14.2 Adding a Read-Only Filegroup to a Database

When you have a filegroup that contains read-only data, a partial backup can be valuable. The partial backup by default excludes any read-only filegroups and backs up only the read/write data that could have changed.

Listing 14.3 contains ...