clucasi (10/11/2013)
The main reason for backing up sequentially is because we are taking a further backup on a tape drive (TSM), if the backups are date based it backs each file, so we get a new on the tape each day, if it was sequentially it would overwrite yesterdays backup.
Don't you want more than 1 day of backups ? Or is it a low priority database ?
You could just use a Maintenance Plan, write your backups to a folder, and keep as much as you want in the folder. Then have your tape back up job back up the folder, so it will grab whatever you want to keep.