对数据库进行定时热备份 --【叶子】收藏
-- =================================
-- Author:<Maco Wang>
-- CreateDate:2009-03-11 10:34:05
-- Description:<数据库定时热备份>
-- =================================
use msdb
create procedure hot_backup
as
begin
declare @sql varchar(200)
set @sql='Maco'+convert(varchar(20),getdate(),120)+'.bak'
set @sql=replace(@sql,'-','');