• I do backups for various solutions - not just SQL server, and with every one I backup to individual files.

    I just keep the filename format the same eg. ddmmyyyyDatabaseBackup.mdb = 13012009DatabaseBackup.mdb

    This removes the single point of failure, and also makes it easy to delete the older files.

    Because I use the same syntax, restores are easy because they can be scripted.