Manualshelf

HP XP P9000 Replication Manager Software 7.6.0-00 Application Agent CLI User Guide

ManualsBrandsHP ManualsSoftwareHP Command View XP Advanced Edition Enterprise Media Kit
281282283284285286287288289290
2. Transaction log backups at point C can be applied after the previous transaction log backup
(point B) is applied.
Recovering the SQL Server database from backup data existing prior to the last backup data
You can recover the SQL Server database from backup data existing prior to the last backup data
when there is a problem in the latest backup data. For example, when you recover the SQL Server
database from the second-last backup data, apply the transaction logs of the second-last backup from
the primary volume to the secondary volume and then apply transaction log backup.
The following figure shows an example of applying a transaction log backup after the last transaction
log obtained for the second-to-last backup from the primary volume to the secondary volume is applied.
By applying the backups as shown in the example, even if a problem exists with the latest backup
data, restoration can be performed to the most recent state, using the second-to-last backup data.
Figure 81 Order of applying transaction log backups (2)
1. Transaction log backups at point B can be applied after the previous volume backup (point A)
is restored.
2. Transaction log backups at point C can be applied after the previous transaction log backup
(point B) is applied.
3. The transaction log backup at point E can be applied after the last transaction log obtained for
the backup from the primary volume to the secondary volume is applied (point C).
SQL Server database requirements for executing commands
To execute the SQL drmsqlxxx command for operating the server database, the SQL Server service
status, database status and database type must be taken into account. The following explains the
requirements for executing commands:
Service status
Table 97 Relationship between the status of the SQL Server service and the executable command
Service status
Commands
StoppingRunning
(Not applicable)Executable
drmsqlbackup
ExecutableExecutable
drmsqlcat
Operation for SQL Server databases286