Which of the following actions should you take?

You work as a database administrator at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
ABC.com has a Storage Area Network that hosts a Sales database. The data file of the Sales
database is 1 TB in size, and is stored on a dedicated LUN that only has 500 GB of useable space

left. The transaction log of the Sales database is 5 GB in size, and is stored on a dedicated LUN
that only has 2.5 GB of useable space left.
A full backup is configured to occur weekly on a Sunday at 10 AM. You have been instructed to
configure backups to occur at 3 hour intervals on a daily basis, Monday to Friday. The first daily
backup should occur at 8 AM, and the last should be at 5 PM. Furthermore, you are informed that
the backups should be minimal in size.
Which of the following actions should you take?

You work as a database administrator at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
ABC.com has a Storage Area Network that hosts a Sales database. The data file of the Sales
database is 1 TB in size, and is stored on a dedicated LUN that only has 500 GB of useable space

left. The transaction log of the Sales database is 5 GB in size, and is stored on a dedicated LUN
that only has 2.5 GB of useable space left.
A full backup is configured to occur weekly on a Sunday at 10 AM. You have been instructed to
configure backups to occur at 3 hour intervals on a daily basis, Monday to Friday. The first daily
backup should occur at 8 AM, and the last should be at 5 PM. Furthermore, you are informed that
the backups should be minimal in size.
Which of the following actions should you take?

A.
You should consider configuring the use of incremental backups.

B.
You should consider configuring the use of differential backups.

C.
You should consider configuring the use of NO_CHECKSUM backups.

D.
You should consider configuring the use of snapshot backups.

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Zemog

Zemog

How does no_checksum minimize backups’ size?, I think snapshot backup does it