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

See Backup utility (dbbackup).

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.