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

--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, ...

Get Microsoft® SQL Server 2012 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.