>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.

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