title: SQL Server 2008 automated nightly database backup
body: <p>I'm using SQL Server 2008 Web Edition and I'd like to create an automated nightly backup that saves the .bak file to a local directory like C:\DB-backups with the following naming structure dbname-date.bak (dbname-07032012.bak).  </p>
  
  <p>I'm not picky about the date format, as long as it's readable and unique.</p>
  
  <p>I'd like to schedule the backup be automated and to run at 3am EST every single night for example.</p>