Need a script which will auto DELETE log backup files > 1 day old. I realize a Maint Plan can do this but looking for a T-SQL script to accomplish the same thing.
My Log backups reside in
[font="Courier New"]
NAME SIZE DATE MODIFIED
F:\Backup\Logs\DB1_Log.bak 74k 2008.07.01
F:\Backup\Logs\DB2_Log.bak 266k 2008.07.02
F:\Backup\Logs\DB3_Log.bak 45k 2008.07.10
[/font]
Any help is greatly appreciated.
BT