Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I define a backup task form the SQL Server 2008 Management Studio. The task creates backup files with name db_backup_YYYY_MM_DD_HHMMSS_ID.bak

Is there a way to change the format. I'm interestet of the weekday db_backup_weekday.bak

share|improve this question
IMHO the format you proposed is far less informative than the default. I assume you want rotate the backups but belive me - something's gonna fail and you won't even notice that backups are not being made. – minder Sep 21 '09 at 12:07
The date/time format is a little bit redundant when the same is on the timestamp for local files. Anyway i was thinking in a program (Studio) with so much options. maybe i could'nt find/see the option for the filename format ... – PeterMmm Sep 21 '09 at 12:57
Actually it is not - you can not select / copy / open files by timestamp. – TomTom Dec 4 '10 at 9:37
up vote 0 down vote accepted

I don't know that you can do this via a maintenace plan. You will probably be able to do this if you write your backup via a script.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.