You have a huge database several hundred gigabytes in size w

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.

Solution

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.\"