Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Maintaining Your Database » 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 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.
    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.