PrepAway - Latest Free Exam Questions & Answers

What should you do to ensure that the backup jobs have a minimal effect on the performance of the server?

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply