• Here is how I parse the name of the backup file

    Select @vDBName = DatabaseName From @vDBList Where DBID = @vCount

    Set @vNewpath = @vBackupPath

    Set @vFileName = @vDBName + '_Full_' + REPLACE(REPLACE(REPLACE(Convert(Varchar(16), GetDate(), 120),'-',''),' ',''),':','') + '.bak'

    Set @vBackupString = 'BACKUP DATABASE [' + @vDBName + '] TO DISK = ''' + @vNewPath + @vFileName +''''