I need to create transaction log backups that are numbered incrementally, one per hour, throughout the day: e.g
9am - dbtlog01.trn
10am - dbtlog02.trn
11am - dbtlog03.trn
I do not want the date or time appended to these because our SAN snapshots will take care of the versioning. I would like to do this without having to create a job for each hour of the day. I just haven't been able to figure this out using T-SQL. Any help on this would be greatly appreciated.