I am trying to create a SQL Job for backing up my database. I want to have:
- A weekly full backup
- A daily differential backup
- Something that will clean up backups that are older that 14 days
I started doing this with the Maintenance Plan, but decided managing it through jobs would be more flexible.
My questions are: how do I name the backup files? Do I name them with a date naming convention and use the same convention to delete old files? Is there an easier way?
If I'm over thinking this and should be using a Maintenance Plan, I would appreciate that answer as well.