SQL 建立数据库备份作业

declare @name nvarchar(50)
declare @datetime char(14)
declare @path nvarchar(255)
declare @bakfile nvarchar(255)
set @name='DBNAME'
set @datetime=CONVERT(char(8),GETDATE(),112)+REPLACE(CONVERT(char(8),getdate(),108),':','')
set @path='D:\DBDataBackup'
set @bakfile=@path+''+'Bak_'+@datetime+'_'+@name+'.bak'
select @bakfile
backup database @name to disk=@bakfile with name=@name,checksum