Hi, I'm having problems configuring our transaction log backups as I would like to.
We run our transaction log backups every 3 hours between 4AM and 7PM (every 3 hours), when i am trying to configure the job in SnapCenter via an "Hourly" policy with a repeat of "every 3 hours" there doesn't appear to be an option to choose between which hours I would like to run the job. The job is created with a default of 00:00 > 23:59:59 when I would like to specify 4:00 > 19:00.
I've tried to get around this by editing the schedule in SQL Management Studio but SnapCenter creates the backup with a schedule of every 180 Minutes, this causes SSMS to error because the max value in Minutes in SQL is 100 therefore 180 is not a valid value.
Our support company suggested this is the correct behaviour and we should be using a poily for each run, i.e. one policy for 4AM, one policy for 7AM etc etc, this seems the opposite of what policies should be used for? With this method I would be going from 3 jobs per server (Weekly Full, Daily Full, TRN) to 1 Resource Group with 7 Policies applied (Weekly Full, Daily Full, TRN for 4AM, 10AM, 1PM, 4PM, 7PM).
Does anybody know of a way to do this or know if this functionality is on the road map at all?
Thanks
Ash