title: Dynamic filename for SQL Server backups?
body: <p>How can you insert the date in the filename (a dynamic filename) used in a T-SQL backup script?  Using SQL Enterprise Manager to create and schedule a backup job, I'd like to edit the T-SQL created to change the filename of the backed up database to be dbname_date.bak (i.e. northwind_5-1-2009.bak).  The next time the backup runs, it will be northwinds_new_date.bak.</p>