We use Backup all databases on a server script by Nigel Rivett from http://www.nigelrivett.net/BackupAllDatabases.html.

> Does anybody have an idea on how to backup on dynamic at the same time trucating backup history. let say for example I want to use 7 day rotation backup on a separate folder
>
>Backup
> d:\backup\Daily\MOnday\Monday.bak
> d:\backup\Daily\Tuesday\Monday.bak
> ......
> .....
>
> d:\backup\Daily\Sunday\Monday.bak...
>
> d:\backup\Daily\Monday\Monday.bak <-- this time delete the backup history first except for last backup.
>
>
>..
> or any solution that would solve the issue. my issue actually is the backup gets bigger and bigger when I used append. but i want also to at least keep last 2 backup then delete least recent backup. tnx