Thanks for the replies guys.

I'm sure this info will help me.

If you are using native SQL 2005 backups (*.bak) then you can couple this piece of code to the end or beginning of your maintenance plan.

EXECUTE master.dbo.xp_delete_file 0,N'FILEPATH',N'BAK',CLEANUPDATE,1

FILEPATH refers to...

One more question:

You mentioned documentation for RedGate sqlbackup?

Our senior DBA has the left the company I am not aware of us having any documentation for this product. We have over...

Thanks for the reply.

I did manage to find that code earlier but am I correct in understanding that in order to cleanup the backups you actually need to take a...

Upon seraching the net further I see that master.dbo.xp_delete_file only deletes native SQL backups (despite allowing for a file extension parameter which makes no sense...)

Is there perhaps a RedGate command...