NEC Storage ReplicationControl SQL Option, Руководство пользователя

Страница: 23 / 104

Chapter 3 Database System Configuration
17
3
3
3
.
.
.
4
4
4
C
C
C
o
o
o
n
n
n
c
c
c
e
e
e
p
p
p
t
t
t
o
o
o
f
f
f
P
P
P
a
a
a
r
r
r
a
a
a
l
l
l
l
l
l
e
e
e
l
l
l
P
P
P
r
r
r
o
o
o
c
c
c
e
e
e
s
s
s
s
s
s
i
i
i
n
n
n
g
g
g
i
i
i
n
n
n
O
O
O
t
t
t
h
h
h
e
e
e
r
r
r
N
N
N
o
o
o
d
d
d
e
e
e
s
s
s
An explanation on using the snapshot backup created by the NEC Storage ReplicationControl SQL
Option for parallel operations on Microsoft SQL Server of other nodes is offered below.
3
3
3
.
.
.
4
4
4
.
.
.
1
1
1
S
S
S
t
t
t
a
a
a
n
n
n
d
d
d
b
b
b
y
y
y
S
S
S
e
e
e
r
r
r
v
v
v
e
e
e
r
r
r
By the snapshot backup, separated database file can be used as a search database by other servers.
The search server must be used as a standby server. For details, refer to the Microsoft SQL Server 2000
Books Online.
In this case, when performing snapshot restoration, specify “-norestore” and then specify “standby” for
the “-remod” option. The database restored through snapshot restoration can be used as the database for
the standby mode.
3
3
3
.
.
.
4
4
4
.
.
.
2
2
2
L
L
L
o
o
o
g
g
g
D
D
D
i
i
i
s
s
s
t
t
t
r
r
r
i
i
i
b
b
b
u
u
u
t
t
t
i
i
i
o
o
o
n
n
n
The database restored as the search database through snapshot restoration can apply backup of
transaction logs updated with the business server in the same manner as the database for the normal
standard mode.
Through this work, data from the search database can be changed to data at the time when the
transaction log was copied as a backup.
3
3
3
.
.
.
4
4
4
.
.
.
3
3
3
S
S
S
e
e
e
r
r
r
v
v
v
e
e
e
r
r
r
A
A
A
c
c
c
c
c
c
o
o
o
m
m
m
p
p
p
a
a
a
n
n
n
i
i
i
e
e
e
d
d
d
b
b
b
y
y
y
U
U
U
p
p
p
d
d
d
a
a
a
t
t
t
e
e
e
Files from the database once disconnected through snapshot backup are used by other servers.
In this case, attach the files of the disconnected database. They can be used in the same manner as the
ordinary database. It is not possible to apply the backup of the transaction log updated by the business
server.
To reflect the data updated by the business server, MV/RV synchronization and separation are required.
3
3
3
.
.
.
4
4
4
.
.
.
4
4
4
F
F
F
i
i
i
l
l
l
e
e
e
s
s
s
O
O
O
p
p
p
e
e
e
r
r
r
a
a
a
t
t
t
e
e
e
d
d
d
i
i
i
n
n
n
P
P
P
a
a
a
r
r
r
a
a
a
l
l
l
l
l
l
e
e
e
l
l
l
When files from the database once disconnected through snapshot backup are operated in parallel
through another node, the files cannot be used as a disk backup.
To use them as a backup, either copying them onto a tape as a backup or use multiple RVs.