Hp XP Command View Advanced Edition Software Uživatelský manuál stáhnout pdf (Strana 319)

100

101

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 “Backing up an SQL Server

database” on page 315.

2. Back up the SQL Server database transaction logs at point B.

For details on how to back up the transaction logs, see “Backing up transaction logs” on page 316.

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 319

1 2 ... 314 315 316 317 318 319 320 321 322 323 324 ... 579 580

Komentáře k této Příručce

Žádné komentáře

Hp XP Command View Advanced Edition Software Uživatelský manuál Strana 319

Komentáře k této Příručce

Související produkty a manuály pro Úložný prostor Hp XP Command View Advanced Edition Software