通过作业来执行
use master
go
declare @date varchar(8)
set @date = Convert(varchar(8),getdate(),112)
declare @sql varchar(1000)
set @sql ='backup database mydbname to disk=''e:\dbbackup\db'+@date+'.bak'' with init'
--print @sql
exec(@sql)
通过作业来执行
use master
go
declare @date varchar(8)
set @date = Convert(varchar(8),getdate(),112)
declare @sql varchar(1000)
set @sql ='backup database mydbname to disk=''e:\dbbackup\db'+@date+'.bak'' with init'
--print @sql
exec(@sql)