ASA Database Administration Guide
  Backup and Data Recovery
    Introduction to backup and recovery

Ways of making backups

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 in Sybase Central to make a backup. You can access the wizard by selecting a database and choosing Backup Database from the File menu (or from the popup menu).

• utility    The dbbackup command-line utility makes backups. For example, executing the following command at the command prompt makes backup copies of the database and transaction log in the directory c:\backup on the client machine:

  dbbackup -c "connection-string" c:\backup

• SQL Statement    You can use a SQL statement to make the database server execute a 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 machine.

  BACKUP DATABASE
  DIRECTORY 'c:\\backup'

• 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.

Notes 

You must have DBA authority or REMOTE DBA authority to make backups of a database.