O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

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

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