Use Tools-> Database Maintenance Planner to automatically generate Job Schedule will produce backup files by date
