Table of Contents
Advertisement
Chapter 6 Operations of NEC Storage ReplicationControl SQL Option
6
.
3
P
6
.
3
6
.
3
Describes operations to starting Microsoft SQL Server 2000 on the search server and using the snapshot
backup as the database of another node without stopping search work by the NEC Storage
ReplicationControl SQL Option. The standby database is used only for searches. Periodically applying the
transaction log offers the advantage of reflecting the latest data without stopping search work.
6
.
3
.
1
6
.
3
.
1
6
.
3
.
1
Data resulting from snapshot backup can be used as the search database.
Data once restored for reference purposes in Microsoft SQL Server 2000 cannot be used as the backup data.
The backup target data and log files will have already been paired and replication will be being executed and
the business server will be being executed and the business server will be running operations.
In this example, the data file and the log file are created in different volumes with the database name as
"snap".
Business Server
Master Volume (MV)
a
r
a
l
l
e
l
O
p
P
a
r
a
l
l
e
l
O
p
P
a
r
a
l
l
e
l
O
p
O
p
e
r
a
t
i
o
n
a
O
p
e
r
a
t
i
o
n
O
p
e
r
a
t
i
o
n
snap
d:
Data file
e:
Log file
f:
Metafile
Shared disk
Figure 6-24 Running as Standby Database
e
r
a
t
i
o
n
o
n
e
r
a
t
i
o
n
o
n
e
r
a
t
i
o
n
o
n
s
S
t
a
n
d
b
y
a
s
S
t
a
n
d
b
y
a
s
S
t
a
n
d
b
y
Used as a search database
snap
d:
Data file
e:
Log file
Replication Volume (RV)
84
A
n
o
t
h
e
r
N
A
n
o
t
h
e
r
N
A
n
o
t
h
e
r
N
D
a
t
a
b
a
s
e
D
a
t
a
b
a
s
e
D
a
t
a
b
a
s
e
Search Server
o
d
e
o
d
e
o
d
e
Advertisement
Table of Contents
