The database or the transaction log, is this? The space issues we have mean that we need to overwrite the backup every night, so it was initially set up (not by me) like this;

BACKUP DATABASE RLT TO DISK='E:\RLA_BACKUPS\RLTBACKUP.BAK'

WITH INIT, FORMAT, NAME = 'Full Database Backup', STATS = 10

I know how to produce a backup file with the date in the name, but where does that leave me when I need it to be overwritten each night?

(And don't worry, I've moved over to the dev environment for now.)