Ben Moorhouse (1/13/2009)

---

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.