SQL Server full backup, differential backup and log backup

A differential backup is a backup of all the differential data that is above a fully-available base point for this period.
A log backup is a backup of the transaction log for this period based on the previous fully prepared + log backup as base point. (log backups are used to ensure that the database is restored to a point in time)
When using a full-standby + log backup, you need to order and restore all log backups individually. Assuming that you want to restore Saturday of data, you will need to have all of your Sunday and Monday to Saturday log backups. If you have a differential daily backup, you only need Sunday of full plus Friday differential backup + Saturday log backup. This is easy to restore, saving time and money. Data normal backup Schedule

1) A full backup of the 2:00:00 execution database in Sunday of each week;

2) 2:00:00 performing a differential backup of the database from Monday to Saturday per week;

3) Perform log backups of the database every 1 hours between 8:00:00 and 23:59:59 every day;

4) 1:00:00 of the last Sunday of each month perform a full backup of the database;

When you need to restore data for a certain point in the day

Select a full backup (does not roll the non-operational transaction), the differential backup of the day (if it is later than 2 o'clock) (does not roll the non-operational transaction), plus log backups

SQL Server full backup, differential backup and log backup