Create backup with filename as date

• sryan-382759

  SSC Journeyman

  Points: 79

  More actions

  March 20, 2007 at 7:45 am

  #123246

  Whats the easiest way to make my sql server agent backup job create a new file on each backup with the date as part of the name?  Do i have to use getdate().  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  March 20, 2007 at 7:57 am

  #695931

  Use a script:

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=71

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1162

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1161

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1843

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  March 21, 2007 at 9:51 am

  #696202

  A SQL Server Maintenance Plan is even easier.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."