Transaction log backup error after roll-forward, Order of applying transaction log backups (1) – HP Serveur lame HP ProLiant BL465c Gen8 User Manual
Page 285
Figure 79 Transaction log backup error after roll-forward
Precautions regarding application of transaction logs
Application of transaction logs enables a database to be recovered from a backup at a certain point,
or when the metafile is damaged. For such a recovery, the transaction logs must be backed up
continuously. Also, a recovery cannot be performed if any transaction logs are missing.
In addition, transaction log files must be applied in the order they were backed up. This subsection
describes the order of applying transaction logs when using the following procedures:
•
Recovering the SQL Server database from the last backup data
•
Recovering the SQL Server database from backup data prior to the last backup data
Recovering the SQL Server database from the last backup data
When you recover the SQL Server database from the last backup data, restore a previous backup
from the primary volume to the secondary volume and then apply transaction logs.
The following figure shows an example of applying transaction log backups after restoring a previous
backup from the primary volume to the secondary volume.
Figure 80 Order of applying transaction log backups (1)
1.
Transaction log backups at point B can be applied after the previous volume backup (point A)
is restored.
Application Agent CLI User Guide
285