Frequency of SQL DB Full and Differential backups I want to know what would be the best frequency in taking SQL DB -  full and differential backups looking at below particular scenario.

I have seven databases and each needs to be backup. 

Currently, I have setup a couple of maintenance plan in SQL as below.


Clean Full Backup every night at 1AM, older than 7 days
Full Backup every night at 2AM
Differential Backup every 1 hour between 5AM to 10PM
Clean Differential Backup Daily 10:30PM, older than 1 day


Considering the full backup size of each Database is 50GB. What would be the optimal way to take backups with 1TB of drive space.

Note that I have different drives for Full and Differential backups of size 1TB and 500GB respectively.

Any suggestions?
The backup policies are actually based on your RPO. But here is my suggestion.
 Use Ola Hallengren's backup script.

If your total size of the DB is &lt; 1 TB


Full Backup - daily 1AM - Retention 7 Days
Differential Backup - Every 12 Hours - Retention 3 days.
Log Backup - Every 15mins - Retention period 1 day.


If your total DB size > 1TB


Full Backup - Weekly once
Differential Backup - Daily once/twice (Based on the database load)
Log Backup - every 15min/30mins