avi7070 (12/9/2016)
Hi,It would be better to schedule FULL, DIFF, and TLog backups for production server databases. As you are not using any not using any high availability technique.
For Point in Time Recovery you will need TLog backups.
I will suggest below Backup Strategy:
FULL – Weekly
DIFF – Daily
TLog – Daily – 1 hour
You can use any suitable backup plan for your server databases, because Any Recovery from backups you need ‘FULL Backup’ or ‘FULL +DIFF’ or ‘FULL Backup – DIFF backup and Tail Log backup’
You must take into the account the activities in the databases, if you have lot of activity then you may have to increase the frequency of the backups, the differentials by the end of the week may come very large and an hour could be a too long interval for the Log backups.
😎