Option to allow for custom text in the backup file name about sql-server-maintenance-solution HOT 5 CLOSED

How about this?

I have the parameter description.
https://ola.hallengren.com/sql-server-backup.html#Description

Some time ago I added support for configuring the file name.
https://ola.hallengren.com/sql-server-backup.html#FileName

I could add a token for Description.

You could then do like this:

@Description = 'BeforeMigration',
@FileName =  '{ServerName}${InstanceName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Description}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}'

from sql-server-maintenance-solution.

I missed that functionality release. It looks like I could probably make that work without any change on your end:

DECLARE @Description NVARCHAR(MAX) = '_TicketNNNN_BeforeManualUpdate_sbryant'
DECLARE @FileName NVARCHAR(MAX) = '{ServerName}${InstanceName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_'+@Description+'_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}'
EXECUTE [dbo].[DatabaseBackup] ... @FileName = @FileName

It sounds like I could take this 3 liner down to 1 if you added that token, but I will leave that up to you since it appears I have a workaround.

Thanks for the information.

from sql-server-maintenance-solution.

@olahallengren Thanks for adding this ability. I remember asking for it a couple few years ago (pre-GitHub days) and had not noticed that it had been added.

from sql-server-maintenance-solution.

I have added the token {Description} now. It can be used in both file names and directories.
https://ola.hallengren.com/versions.html

Any characters that are not allowed in the file system are removed.

from sql-server-maintenance-solution.

Wow, super fast turnaround! Thanks Ola!

from sql-server-maintenance-solution.