f
Set the
Starting at
to
06:30:00 AM
and
Ending at
to
06:29:59 AM
.
i
Verify that the
Recurs
field is set to
1
day(s).
ii
In the
Daily Frequency
section, check
Occurs every
, type
4
and select
hour(s)
.
iii
Set the
Starting
at time to
06:30 AM
and the
Ending at
time to
06:29:59 AM.
iv
In the
Duration
section, confirm the start date is set to the current date and
No end date
is selected.
v
Click
OK
to accept schedule update.
vi
Click
OK
to complete backup job creation.
11
Repeat these steps until all databases (excluding
tempdb
) have a backup job.
12
To create an SQL Server backup file management job, go to step 8 and make the following
modifications:
a
Type
BAK file management
as the job description.
b
Select
master
for the
Database
field.
c
For
Command
field, use this text:
-- SQL Server Transact SQL script to perform backup file management
--
-- Use this script to manage the BAK files created by the backup jobs. Modify
-- the following variable for the shared location of the backup files –
--
-- DIRNAME = Set location of the backup files
--
DECLARE @dt datetime, @DIRNAME VARCHAR(40)
--
SET @DIRNAME = 'I:\Backups\';
--
select @dt = getdate() - 1
EXECUTE master.dbo.xp_delete_file 0,@DIRNAME,N'BAK',@dt
You can optionally type a directory location and file name into the
Output file
field
to capture script log messages. For example,
Filemgmt.log.
d
Use the same schedule as the
master
database.
13
To verify the backup job, right-click a backup job and select
Start Job at Step
.
Guidelines for backing up system configuration files
|
132
