首先,新建维护计划:
拖取“执行T-SQL语句任务”到计划中,如上图所示
鼠标右键点击,选择编辑
键入SQL语句
EXECUTE master.dbo.xp_create_subdir N'\\192.168.0.16\K3WiseDBBackup\Backup' GO DECLARE @PATH nvarchar(255); SET @PATH='\\192.168.0.16\K3WiseDBBackup\Backup\KDAcctDB_backup_' + replace(replace(replace(convert(nvarchar(32),getdate(),126),'.','_'),':','_'),'-','_') +'.bak' ; BACKUP DATABASE [KDAcctDB] TO DISK = @PATH
\\192.168.0.16\K3WiseDBBackup\Backup
是网络路径,要给与当前用户读写权限,否则会出错