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