d
Type a description in the
Description
field.
e
Verify
Enabled
is checked.
8
To create a new job step entry, under
Select a page
, select
Procedure (Steps)
, and then click
New
.
a
From the
New Job Step
window, in the
Step name
field, type
Backup
or other text.
b
Verify that the default value is set in the
New Job Step windowType
field.
c
Leave the
Run as
field empty.
d
In the
Database
field, select the database to be processed.
e
Copy and paste this text into the
Command
area, and modify the
@DIRNAME
and
@DBNAME
variables accordingly:
-- SQL Server Transact SQL script to perform database backup
--
-- Use this script for each of the databases in the {AMP or AMP-2}. Modify the following
variable
-- for the shared location of the backup files –
--
-- DIRNAME = Set location of the backup files
--
-- Modify the following variable for the name unique to each database:
--
-- DBNAME = Set database name
--
DECLARE @DIRNAME VARCHAR(40), @DBNAME VARCHAR(40), @SUFFIX VARCHAR(48),
@FILENAME VARCHAR(128);
--
SET @DIRNAME = 'I:\Backups\';
SET @DBNAME = 'master';
--
SET @SUFFIX = '_FULL_' + convert(varchar(8),getdate(),112) + '_' + replace
(convert(varchar(8),
getdate(),108),':','')+ '.bak';
SET @FILENAME = @@@SUFFIX;
BACKUP DATABASE @DBNAME TO DISK=@FILENAME WITH NAME=@DBNAME,SKIP,STATS=20;
--
f
Under
Select a page
, select the
Advanced
tab.
g
For the
On success action
field, select
Quit the job reporting success
.
h
Under
Select a page
, select the
Advanced
tab. You can optionally type a directory location
and file name into the
Output file
field to capture script log messages. For example,
I:/
Backups/master.log
.
i
Click
OK
.
9
To create the job schedule, under
Select a page
, select
Schedules
, and click
New
.
a
From the
New Job Schedule
window, type a
Name
for the job schedule.
151
|
Guidelines for backing up configuration files
Содержание Vblock Systems 350
Страница 1: ...Dell EMC VxBlock and Vblock Systems 350 Administration Guide Document revision 1 8 October 2017 ...
Страница 114: ...Related information VMware vSphere Networking guide Managing VMware VDS 114 ...
Страница 122: ...Related information Cisco Nexus 1000V Troubleshooting Guide Managing the Cisco Nexus 1000V Series Switch 122 ...
Страница 156: ...4 On the Schedule tab schedule the task to run daily at 1 00 AM Backing up Cisco MDS switches 156 ...
