Sybase DC38133-01-0902-01 Backup procedures at remote databases, Restart your system as normal

Chapter 11. Administering SQL Remote for Adaptive Server

Anywhere

4. Apply the renamed transaction logs in order, as follows

dbeng9 -a C:nDBDIRndate00.LOG C:nRECOVERnCONS.DB

dbeng9 -a C:nDBDIRndate01.LOG C:nRECOVERnCONS.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:nRECOVERnCONS.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 You can use the -xMessage Agent option to eliminate the need to rename

renamingthe transaction log on the remote computer when the database server is shut down. The -xoption renames transaction log after it has been scanned for outgoing messages.

257