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.