search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

Include the name of the day, for daily differential backups. #791

Open EclipsingTechno opened 9 months ago

EclipsingTechno commented 9 months ago

Is there currently a parameter in the naming portion of Ola Hallengren backup command that lets you put the name of the day in the filename when creating a DIF backup with SQL Server? (i.e. Monday, Tuesday, or MON, TUE, etc.)

I would like to have 1 DIF backup per day that has that days name in the filename (like TEST_DIF_Monday.bak). Currently the {day} parameter puts the number of the day of the month, like 1, 2, 21, 30, etc.

Thanks,

Greg

olahallengren commented 3 weeks ago

Would it work if I added a token for the day of the week? https://ola.hallengren.com/sql-server-backup.html#FileName