SQLServer 2008 : Name of backup file

Question

Hello

I have a SQL server 2008 and I would change the name of the backup file. I use an SSIS package to perform my backups.

The file's name looks like

[DATABASE_NAME]_backup_YYYY_MM_DD_XXXXXX_XXXXXX

This is automatically generated by SqlServer, and I want to remove the "_".

How I can modify this ?

Thank you in advance,

Andy.

Answer 1

I believe that you can use the DestinationManualList for this, although I've never used it myself and I can't seem to find documentation or examples of it anywhere. It appears in the Properties list for the Backup Database Task, but not in the dialog for it.

Answer 2

But nobody knows if its possible to modify this format ? From config file or the registry ?