Sript Name with Current Date

• erdem1973

  SSCommitted

  Points: 1843

  More actions

  October 12, 2006 at 2:48 am

  #114695

  How to name a string with the current date??Please help

  BACKUP DATABASE [CollSoftware2]

  TO  DISK = N'C:\01_01_2006.bck' WITH  INIT , NOUNLOAD , Name = N'CollSoftware2',  NOSKIP ,  STATS = 10,  NOFORMAT

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  October 12, 2006 at 3:35 am

  #665414

  The ISO date format is probably best for this; so something like:

  DECLARE @DiskStr NVARCHAR(255)

  SET @DiskStr = N'C:\CollSoftware2_' + CONVERT(NVARCHAR(8), GETDATE(), 112) + N'.bak'

  BACKUP DATABASE [CollSoftware2]

  TO  DISK = @DiskStr

  WITH  INIT , NOUNLOAD , Name = N'CollSoftware2',  NOSKIP ,  STATS = 10,  NOFORMAT