You have a huge database, several hundred gigabytes in size, with the recovery m

Question

You have a huge database, several hundred gigabytes in size, with the recovery model set to Full. With your current hardware, a full backup of this each takes 15 hours. You cannot have the backup running during working hours because you do not have the system resources available to support users while performing a backup. Which backup strategy should you use?

a. Perform a full backup every night.
b. Perform a full backup and transaction log backup every night.
c. Perform a full backup every weekend and a differential backup every weeknight.
d. Perform a full backup every weekend, a differential backup every weeknight, and a transaction log backup every night.

Explanation / Answer

Since doing a full backup is very long process so the best option that can be used is "b. Perform a full backup and transaction log backup every night."

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.