How to Name the SQL Backup file?

FinalBuilder Discussion
1

Is there a way to name the backup file when using the SQL Server Backup Database action?

My backup gets named MyApp_db_200806130852.BAK and I want to name it MyApp.BAK.

Thanks

2

Hi Bob,

AFAIK you can’t set the name of the backup file when you set up a new maintenance plan, and it looks like the sqlmaint.exe doesn’t allow you to specify the name of the file either.