An incremental backup is a type of online backup. An incremental backup is a backup of the transaction log only and can only be used for recovery if you have run a full backup before running the incremental backup. Full backups can be interspersed with several incremental backups. See Full backups.
Connect to the database as a user with REMOTE DBA or BACKUP authority.
Perform a validity check on your database to ensure that it is not corrupt. You can use the Validation utility or the sa_validate stored procedure.See Validating a database.
Make a backup of your transaction log, not your database file.
The backup copies of the database file and transaction log file have the same names as the online versions of these files. For example, if you make a backup of the sample database, the backup copies are called demo.db and demo.log. When you repeat the backup statement, choose a new backup directory to avoid overwriting the backup copies
For information about making a repeatable incremental backup command by renaming the backup copy of the transaction log, see Transaction log backup copy naming.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|