DECLARE @bkfile nvarchar(1000) SET @bkfile='E:\beifen_db\UCoupon'+replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','') +'.bak' backup database UCoupon to disk=@bkfile