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 database 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?

Solution

If 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 database 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. Then...

Answer :-

You should use the backup strategy :-

STEP1 :-

Perform a full backup every weekend which backup the entire database.

STEP2 :-

Pereform a differential backup every weeknight which record only the changes made to the database since the last full backup.

STEP3 :-

Perform a transaction log backup every night which backup and clear the log.