对数据库进行定时热备份 --【叶子】收藏 -- =================================
-- Author:
-- 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,'-','');
set @sql=replace(@sql,' ','');
set @sql=replace(@sql,':','');
select @sql
backup database maco to
