You have a VLDB with four filegroups Primary FG1 FG2 FG3 wit

You have a VLDB with four filegroups (Primary, FG1, FG2, FG3), with the recovery model set to Full. You want to back up your database in the shortest time possible while being able to restore in the shortest time possible. Which backup strategy should you use?

a. Perform a full backup once a month , filegroup backups once a week, and transaction log backups throughout the week.
b. Perform a full backup once a month, filegroup backups once a week, and differential backups throughout the week.
c. Perform a full backup once a week and transaction log backups throughout the week.
d. Perform a full backup every night .

Solution

a. Perform a full backup once a month , filegroup backups once a week, and transaction log backups throughout the week.
b. Perform a full backup once a month, filegroup backups once a week, and differential backups throughout the week.
c. Perform a full backup once a week and transaction log backups throughout the week.
d. Perform a full backup every night .