Example of operation using transaction log backup – HP Serveur lame HP ProLiant BL465c Gen8 User Manual
Page 317
Example of operation using transaction log backup
If a failure occurs, you can restore the database up to the point of the last backup by using the data
and transaction logs backed up during regular operation before the failure occurred. However, when
you use only backups under normal operation, since operations performed after the last backup is
truncated, such operations cannot be restored.
To restore a database to its state immediately before failure, you need to obtain the transaction logs
from the last backup until the point immediately before failure. This subsection explains an example
in which transaction logs are obtained without truncation, and the database is restored to the state
immediately before failure. The operation ID is
Operation_A
.
Figure 92 Operations using SQL Server transaction log backup (restoring a database to the state it
was immediately before failure)
To back up an SQL Server database and transaction logs during regular operation:
1.
Back up the SQL Server database at point A.
For details on how to back up the database at point A, see “
2.
Back up the SQL Server database transaction logs at point B.
For details on how to back up the transaction logs, see “
Backup is performed without truncating the transaction logs after failure occurs at point D.
To obtain the transaction logs after failure:
Application Agent CLI User Guide
317