You design a Business Intelligence (BI) solution by using SQL Server 2008. The SQL Server 2008 instance hosts a database. The database is currently scheduled for a full backup on a monthly basis.
The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup. The database uses the bulk-logged recovery model.
You need to back up the database changes to a tape drive every night by using minimum storage space and time.
Which backup strategy should you use?
A.
File backup
B.
Partial backup
C.
Differential backup
D.
Differential Partial backup
Explanation:
Tip: "read-only filegroup" = "Differential Partial backup"http://msdn.microsoft.com/en-us/library/ms191539.aspx
Partial Backups
Partial backups were introduced in SQL Server 2005. Partial backups are designed for use under the simple recovery model to improve flexibility for backing up very large databases that contain one or more read-only filegroups. However, partial backups work on all databases, regardless of recovery model.
Note
For an overview of the various types of backups, see either Backup Under the Simple Recovery Model or Backup Under the Full Recovery Model.
A partial backup resembles a full database backup, but a partial backup does not contain all the filegroups. Instead, a partial backup contains all the data in the primary filegroup, every read/write filegroup, and any optionally-specified read-only files. Partial backups are useful whenever you want to exclude read-only filegroups. A partial backup of a read-only database contains only the primary filegroup.