set @myTime=getdate()
set @myBak='e:\bk-datas\dbname'
set @myBak=@myBak+convert(char(8),@myTime,112)
set @myBak=@myBak+cast(DATEPART(hh, @myTime) as varchar(2))
set @myBak=@myBak+cast(DATEPART(mi, @myTime) as varchar(2))
set @myBak=@myBak+cast(DATEPART(ss, @myTime) as varchar(2))
set @myBak=@myBak+'.bak'
--select @myBak
backup database IISLOGS to disk=@myBak
--创建备份当前数据库的存储过程
create proc p_backupdb
as
declare @sql varchar(8000)
set @sql='backup database '+db_name()+' to disk=''c:\'+db_name()
+convert(varchar,getdate(),112)+'.bak'''
exec(@sql)
go