declare @date date = getdate()
declare @cmd varchar(max)

--резервируем
set @cmd = ''
select @cmd = @cmd + 'backup database [' + [name] + '] to disk = ''d:\MSSQL\Backup\' + replace(convert(varchar(10),@date,121),'-','') + '_' + [name] + '.bak'' with format, compression, medianame = ''' + host_name() + '_backup'', name = ''Full backup of ' +  [name] + ' at ' + convert(varchar(10),getdate(),121) + ''''  + char(10)
from sys.databases where [name] in ('StatDB1','StatDB2','StatDB3','StatDB4','StatDB5','StatDB6') order by [name]
exec (@cmd)