>>How do I set up the SQL Server backup feature so that it overwrites the previous backup file, instead of creating a new one each night?
>
>You have guts! Spread your risk and get a few days of backups.

The backup is to another disk, that is then backed up to tape each night. So we do have daily copies on tape with the latest being the one on disk (for fast recovery).

>How are you making your backups now? holdover code from 2000 or did you code it in 2005 yourself?

Just the SQL Backup tool in Mgt Studio.