You administer a SQL Server 2008 instance that hosts a large database. The database
experiences high volumes of queries and transactions that are processor-intensive. You
plan to implement an incremental backup strategy for the database. You also plan to use
backup compression. You need to ensure that the backup jobs have a minimal effect on the
performance of the server. What should you do?
A.
Use database snapshots.
B.
Use the Resource Governor.
C.
Reconfigure the Affinity I/O Mask configuration option.
D.
Spread the database backup across multiple backup devices.