declare @s varchar(1000)
set @s=replace(replace(replace(convert(char(20),getdate(),120),'-',''),':',''),' ','')
backup database items to disk='''c:\''+@s+''\itemsbk.bak'''
set @s=replace(replace(replace(convert(char(20),getdate(),120),'-',''),':',''),' ','')
backup database items to disk='''c:\''+@s+''\itemsbk.bak'''
declare @bkname varchar(15)
set @bkname = replace(convert(varchar(10),getdate(),120),'-','')
backup database items to disk='C:\ItemsBak\'+@bkname+'itemsbk.bak'