sql job定时备份数据库

----------------------------------------

对TestDB1进行备份

----------------------------------------

declare@namevarchar(250)
set@name='C:\Backup\TestDB1_'+
convert(varchar(50),getdate(),112)+'.bak'
BACKUPDATABASE[TestDB1]TO
DISK=@name
WITH NOFORMAT, NOINIT,
NAME = N'TestDB1-完整 数据库 备份',
SKIP, NOREWIND, NOUNLOAD