Recovery with a single transaction log
Inthis case, we assume that there is a single transaction log file, which has
existedsince the database was created. Also,we assume previous backups of
thedatabase file have been made and are available, for example on tape.
❖Torecover the database
1. Make a copy of the database and log file.
2. Restore the database (
.db
)file,
not
thelog file, from tape into a
temporarydirectory.
3. Start the database using the existing transaction log and the -a option, to
applythe transactions and bring the database file up to date.
4. Startthe database in your normal way. Any new activity will be appended
tothe current transaction log.
X
Transaction log
(intact)
Database file
(corrupt)
Media failure
on the
database file
Transaction log
(intact)
Old database
file (intact)
Restore
backed up
database file
Transaction log
(intact)
Database file
(restored)
Start
database
with
transaction
log
254