declare @dbname varchar(100)
declare @dbbakname varchar(100)
set @dbname='dbname'
set @dbbakname=replace(replace(replace(convert(datetime,getdate()) ,'-',''),' ',''),':','')
exec('BACKUP DATABASE '+@dbname+' TO DISK = N''D:\'+@dbname+@dbbakname+'.bak'' WITH NOINIT , NOUNLOAD , NAME = N'''+@dbname+' 备份'', NOSKIP , STATS = 10, NOFORMAT ')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货