Backups - Using SQL Agent Tokens to Set the Date, and Why to go MultiFile
Category:
backup-recovery
My life is a bit easier since I learned how to use SQL agent tokens. They are particularly nice for setting date and timestamps on backup files. Unfortunately, they only work in the context of executing agent jobs.