If disk space is not a problem on your production computer (where the database server is running) then you do not need to worry about choosing special options to manage the transaction log file or the checkpoint log. In this case, you can use an image backup. The simplest image backup makes copies of the database file and transaction log, and leaves the transaction log in place. All backups leave the database file in place.
A full backup of this kind is illustrated in the figure below. In an incremental backup, only the transaction log is backed up.
For more information about full backups, see Making a backup, continuing to use the original transaction log.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |