Transaction Logs running 24x/day. But job def doesn't request that
I have 10 Servers with databases on them. Each Server runs transaction log backups 12x/day.
Three strange things at hand.
1) I create Inc 2, Inc 3, Inc 4, Inc 5 to total 12 Incremental jobs. And when I look at the properties of the job, It appears to 'alphabetize' the Incrementals becasue when I look at the job to edit it, all my Incrementals show in the following order. Inc10, Inc11, Inc12, Inc13,Inc14, Inc1, Inc2, Inc3, Inc4, Inc5, Inc6, Inc7, Inc8, Inc9
...and I wonder if this is causing my issue of:
2) About 1/2 of my Servers run these transaction log backups every hour 24 hours a day even though the job definition doesn't request that.
3) One Server in particular has the same 12 Incrementals, but the job history shows Incremental #7 runs on the 12 hours / day that it isn't supposed to be running.