Regarding Backup and Restore Strategy I have some questions regarding backup and restore strategies.

I want to take backup and restore of large databases approx. 60 to 70 GB and it is a critical database on SQL Server.

Backup schedule approx. I decided to:


Full backup every day
Differential backup every 2 or 3 hours
Transaction-log backup every 15 minutes


Is this a correct approach? If not then please suggest better option.

Which recovery model is best suited? (Simple, Full, Bulk-logged)

In case any of the backup files (full backup file, differential backup file or log backup) are corrupted, then what are the options to recover database quickly with minimum data loss?
Your backup plan seems to be good. Of course, everything depends on:

Recovery Point Objective (RPO) in other words – how much data can you afford to lose?

And

Recovery Time Objective (RTO) if database disaster occurs, how much time are you able to spend restoring a database to its working condition?

Note, if you will run your database under the simple recovery model you will not able to make  transaction log backups.