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

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

Chapter 6 Operations of NEC Storage ReplicationControl SQL Option
58
6
6
6
.
.
.
1
1
1
.
.
.
3
3
3
R
R
R
e
e
e
c
c
c
o
o
o
v
v
v
e
e
e
r
r
r
y
y
y
The procedure for performing recovery from the backup obtained through snapshot backup is described here.
It is assumed that errors occurred in MV’s data file and the backup and the metafile previously where
snapshot backup was obtained are stored in the tape.
In this example, the data file and the log file are created in different volumes with the database name as
snap.
Figure 6-9 Performing Snapshot Restoration
If an error occurs in the data file disk but not in the log file disk, a transaction log backup can be created
with Microsoft SQL Server 2000. In this case, recovery until immediately before the error is made possible
by applying the transaction log when the error occurs in the log file disk.
In the event that transaction log backups have been made periodically, recovery shall be possible until the
latest transaction log backup copy is created if an error occurs in the log file disk.
If the transaction log backup file is lost, recovery until the transaction log backup is created becomes
impossible. Save the transaction log backup file in a high-reliable disk.
e:
d:
Data file
Business Server
Backup Server
Tape
Backup software such as
ARCserve
BackupExec and
NetBackup
Errors occurred
in the data disk!
Data file
Log file
Log file
Master Volume (MV)
Replication Volume (RV)
f:
Shared disk
Metafile