delete old files using tsql

[gday2u]

I am relatively new to SQLserver and I am putting together
some TSQL code to backup our databases and transaction logs.
I want to also include some code which will delete backup
files older than a specified number of days.

Has anyone written some code to do this ?

TIA

 

[fluteplr]

You seem to be reinventing the wheel.

Open up Enterprise manager.

Find Management in the tree on the left. Open it up and find database maintenance plans. Use the wizard to create a backup plan.

It will do all the thing you listed in about 2 minutes of clicking on buttons. No code required.