SqlServer 自动备份作业

进入企业管理器中->管理->Sql Server 代理->作业

declare @FullPath varchar(1000)
set @FullPath = 'C:\DataBaseBak\' + convert(varchar(4), year(getdate()))+right('0'+convert(varchar(2), month(getdate())),2)+right('0'+convert(varchar(2), day(getdate())),2) + '.bak'
backup database SuperBlog to disk=@FullPath with init