Microsoft® SQL Server 2012 Unleashed

Partial Backups

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

LISTING 11.2 Adding a Read-Only Filegroup to a Database

Click here to view code image

--Need to add a read only filegroup first to demonstrateALTER DATABASE AdventureWorks2012ADD FILEGROUP ReadOnlyFG1GO-- Add a file to the FilegroupALTER DATABASE AdventureWorks2012ADD FILE(    NAME = AdventureWorks2012_ReadOnlyData,    FILENAME ='C:\mssql\data\AdventureWorks2012_ReadOnlyData.ndf',    SIZE = 5MB, ...