However, if you need more flexibility in the naming of the dump file (or other criteria), I’d suggest creating a single proc that’s scheduled every hour to do the backups. If it’s the first log dump of the day (based on a datediff check with getdate() or perhaps based on a query of the last full backup time), init the backup file; otherwise, append.