SQL backup scheduling question
The schedule I use currently is depicted in the attached image. The difference b/t each of the schedules is the Frequency/retention time. It's been and still is working just fine.
But question is whether it's necessary to have all of the different "Automatic" schedules for each of the "Application" back ups, or could we somehow have one "Automatic" schedule that was 24x7? I ask b/c the attributes for the "Application" backups don't appear to allow me to specifiy a frequency, so I don't see how I could get the results I'm after w/o having a separate corresponding "Automatic" schedule for each "Application" backup that requires a unique frequency; short of creating a separate Policy for each.