I am currently doing “nightly” backups to NAS for my DB’s.
I want to setup a new job that will run every two hours and backup to a different NAS. Our Db’s change constantly so I need to have more current backups in case of system failure.
I was doing this another way by making copies of the ldf and mdf files and using a volume shadow. These files are open at all times while the server is running.
I am looking at alternatives.
I only need to keep one backup, the most current. There is no option to overwrite backups and the auto delete option only specifies days and not hours.
Is this possible?