Sql备份数据库

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