I use this script on some (not all) databases to backup the Logs when they reach a certain level of being full. For example, when the log is 60% full the log will be backed up.
Change the ????? values and this script is ready to go.
Is there a way I can automate a file deletion process from within SQL Server?