There are several distinct ways of making backups. This section introduces each of the major approaches, but does not address any issues of appropriate options.
You can make backups in the following ways:
Sybase Central You can use the Backup Database Wizard or Create Backup Images Wizard in Sybase Central to make a backup. You can access these wizards by selecting a database and choosing Backup Database or Create Backup Images from the File menu (or from the popup menu). See Backing up a database directly to tape.
You can also use the Create Maintenance Plan Wizard in Sybase Central to validate and back up your database on a regular schedule. See Creating a maintenance plan.
Backup utility The dbbackup utility makes client-side backups. For example, executing the following command makes backup copies of the database and transaction log in the directory c:\backup on the client computer:
dbbackup -c "connection-string" c:\backup
You can make a backup copy of the database and transaction log in the directory c:\backup on the server computer by specifying the -s option:
dbbackup -c "connection-string" -s c:\backup
SQL statement You can use a SQL statement to make the database server execute a server-side backup operation. For example, the following statement places backup copies of the database file and transaction log into the directory c:\backup on the server computer.
BACKUP DATABASE DIRECTORY 'c:\\backup';
See BACKUP statement.
You can also issue a BACKUP DATABASE statement using the dbbackup -s option. See Backup utility (dbbackup).
Offline backup The above examples are all online backups, executed against a running database. You can make offline backups by copying the database files when the database is not running.
See Types of backup.
You must have BACKUP authority or REMOTE DBA authority to make online backups of a database.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|