I created SQL server scheduled backup as follow :
Full: 2 times a week
Differential: 6 hours a day
Log: 3 hours
The problem I am having is that after one month I end up with a backup file of size 30GB and that is too heavy to restore, knowing that one full backup is only 1 GB max.
Can I, for example, each week save the .bak file (created as described above) somewhere and delete it from the SQLSERVER backup folder (delete it just after the last log backup that is before the next full backup occurs), so that the next week a new Full backup will be created then Differential and Log.
Or you may have a better strategy, then please elaborate.