User's Manual
Chapter 11. Administering SQL Remote for Adaptive Server
Anywhere
4. Apply the renamed transaction logs in order, as follows
dbeng9 -a C:\DBDIR\date00.LOG C:\RECOVER\CONS.DB
dbeng9 -a C:\DBDIR\date01.LOG C:\RECOVER\CONS.DB
5. Copy the current transaction log,
c:\dbdir\cons.log
to the recovery
directory, giving
c:\recover\cons.log
.
6. Start the database using the following command:
dbeng9 C:\RECOVER\CONS.DB
7. Shutdown the database server.
8. Backup the recovered database and transaction log from
c:\recover
.
9. Copy the files from
c:\recover
to the appropriate production directories.
♦ Copy
c:\recover\cons.db
to
c:\dbdir\cons.db
.
♦ Copy
c:\recover\cons.log
to
c:\dbdir\cons.log
, and to
d:\mirdir\cons.mlg
.
10. Restart your system as normal.
Backup procedures at remote databases
Backup procedures are not as crucial at remote databases as at the
consolidated database. You may choose to rely on replication to the
consolidated database as a data backup method. In the event of a media
failure, the remote database would have to be re-extracted from the
consolidated database, and any operations that have not been replicated
would be lost. (You could use the log translation utility to attempt to recover
lost operations.)
Even if you do choose to rely on replication to protect remote database data,
backups still need to be done periodically at remote databases to prevent the
transaction log from growing too large. You should use the same option
(rename and restart the log) as at the consolidated database, running the
Message Agent so that it has access to the renamed log files. If you set the
DELETE_OLD_LOGS option to ON at the remote database, the old log
files will be deleted automatically by the Message Agent when they are no
longer needed.
Automatic transaction log
renaming
You can use the -x Message Agent option to eliminate the need to rename
the transaction log on the remote computer when the database server is shut
down. The -x option renames transaction log after it has been scanned for
outgoing messages.
257