Delete old back up files from SQL command

[dhulbert]

My backup routine creates a new backup file each day and adds all the incremental backups to that file. Then next day new file etc, It's all very tidy and easy to administer but I want to delete the old files automatically from the same SQL script.

How do I delete files on a disk where they are over a certain age

Any help appreciated thanks.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[simian336]

You can run xp_cmdshell to run DOS DEL command...

Simi