I have a series of databases that require backups during the day. I have one full database backup running at night presently. However, I would like to run transaction log backups every 15 mins through the day. I want the log backup filenames to reflect the time of day they were created, for example, a log created on 9/12/2002 at 9:15am could be something like 09122002-091500.bak. I also want each backup file to be an individual file ie. several files for one working day.
Any ideas??