Contents

1 豌企葦 : 襷れ 殊 01:00 豌企葦
2 谿焔葦: 襷れ 01:00 谿焔葦
3 襦蠏碁葦: 00:00:00 ~ 23:59:59 伎 襦蠏碁葦 4覯


覓語 覦煙 れ 蟆 襴る . SQL Server 2000..

1 豌企葦 : 襷れ 殊 01:00 豌企葦 #

--豢螳
USE msdb
EXEC sp_add_job @job_name = 'Full Backup'

--殊
EXEC sp_add_jobschedule @job_name = 'Full Backup', 
   @name = '殊 豌企葦',
   @freq_type = 8, --襷れ
   @freq_interval = 1, --殊
   @active_start_time = 10000, --HHMMSS, 1
   @freq_recurrence_factor = 1

--螻豢螳
EXEC sp_add_jobstep @job_name = 'Full Backup',
   @step_name = '殊 豌企葦',
   @subsystem = 'TSQL',
   @command = 'backup database [一危磯伎る] to disk = ''[蟆暑覈]'' 

exec master..xp_cmdshell ''del [襦蠏碁葦覲 蟆暑]'''

2 谿焔葦: 襷れ 01:00 谿焔葦 #

--豢螳
EXEC sp_add_job @job_name = 'Diff Backup'
 
--殊
EXEC sp_add_jobschedule @job_name = 'Diff Backup', 
   @name = '襷れ 谿焔葦',
   @freq_type = 4, --襷れ
   @freq_interval = 1, --覯
   @active_start_time = 10000 --HHMMSS, 1
 
--螻豢螳
EXEC sp_add_jobstep @job_name = 'Diff Backup',
   @step_name = '襷れ 谿焔葦',
   @subsystem = 'TSQL',
   @command = 'backup database [一危磯伎る] to disk = ''[蟆暑覈]'' with differential'

3 襦蠏碁葦: 00:00:00 ~ 23:59:59 伎 襦蠏碁葦 4覯 #

--襦蠏碁葦 レ 豢螳
EXEC sp_addumpdevice 'disk', 'logbackup', '[襦蠏碁葦覲瑚化襦]'

--豢螳
EXEC sp_add_job @job_name = 'Log Backup'

--殊
EXEC sp_add_jobschedule @job_name = 'Log Backup', 
   @name = '襦蠏碁葦1',
   @freq_type = 4, --襷れ
   @freq_interval = 1, --覯,
   @active_start_time = 000000,
   @freq_subday_type = 0x8,
   @freq_subday_interval = 6

--螻豢螳
EXEC sp_add_jobstep @job_name = 'Log Backup',
   @step_name = '襦蠏碁葦1',
   @subsystem = 'TSQL',
   @command = 'backup log [一危磯伎る] to disk = logbackup'