NEC Storage ReplicationControl SQL Option, User Manual

Page: 28 / 104

Chapter 4 Functions of NEC Storage ReplicationControl SQL Option
22
4
4
4
.
.
.
2
2
2
C
C
C
o
o
o
m
m
m
m
m
m
a
a
a
n
n
n
d
d
d
s
s
s
Commands used on the NEC Storage ReplicationControl SQL Option are described below.
Table 4-1 Lists of the NEC Storage ReplicationControl SQL Option Commands
Command name Operation name Description
iSMsql_snapshotbkup
Snapshot backup Backs up database.
iSMsql_snapshotrst
Snapshot restore Restores database from backup.
* Operation rights are required for the users belonging to Administration group.
When using the NEC Storage ReplicationControl SQL Option’s commands, it is necessary to specify a
configuration so that the NEC Storage ReplicationControl directly issues the replication operation I/O
issuing path to the disk array.
For explanation about commands and operation settings, refer to the “NEC Storage Data Replication
Command Reference”.
4
4
4
.
.
.
2
2
2
.
.
.
1
1
1
S
S
S
n
n
n
a
a
a
p
p
p
s
s
s
h
h
h
o
o
o
t
t
t
B
B
B
a
a
a
c
c
c
k
k
k
u
u
u
p
p
p
C
C
C
o
o
o
m
m
m
m
m
m
a
a
a
n
n
n
d
d
d
Snapshot backup uses the iSMsql_snapshotbkup command.
By instructing Microsoft SQL Server 2000, iSMsql_snapshotbkup command freezes the update I/O,
creates the metafile for the specified path and records the database configuration and the transaction log
state. Thereafter, it separates the MV and the RV where the specified database is stored.
After the separation is completed, the command sends the completion instruction to Microsoft SQL
Server 2000, which in turn creates the history in the MSDB.
The following options can be specified for the iSMsql_snapshotbkup command regarding snapshot
backup operation.
(1) Specifying the database name (-db dbname or –dbfile dbfile_name)
A name recognized by Microsoft SQL Server 2000 can be specified as the database name.
When simultaneously performing snapshot backups on multiple databases, specify multiple
database names in the database operation file.
For details of the database operation file, refer to the “NEC Storage Manager Data Replication
Command Reference”.
(2) Specifying the metafile (-metafile metafile_name or –metafolder
metafolder_name)
For the metafile, a metafile name created during snapshot backup can be specified.
When simultaneously performing snapshot backups on multiple databases, specify the name of the
folder that stores metafiles. Under the specified folder name, multiple metafiles that correspond
to each database on which a snapshot backup has been performed are created. The name of the