Append datetime in backup file.

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  July 28, 2010 at 10:15 pm

  #227264

  HI,

  I have created a job in SQL server 2005 to take full backup & in another step it copies the .bak file to different location. I want to append date time in .bak file while taking backup. I want format like this: -

  my db name is ict.

  format I want is: - test201007291250.bak

  dbname/yy/mm/dd/timestamp.bak

  Thanks in advance.

• rothj

  Hall of Fame

  Points: 3412

  More actions

  July 30, 2010 at 7:35 am

  #1200319

  See if this script helps:

  http://www.sqlservercentral.com/scripts/backup+restore+recovery/70539/

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  July 30, 2010 at 9:59 am

  #1200454

  The Maintenance Plans available in the SQL Server 2005 does this without the need of writing scripts.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Rick.Cornell.SME

  SSCrazy Eights

  Points: 8597

  More actions

  July 30, 2010 at 12:14 pm

  #1200498

  LOL 😀