Introducing SQL Anywhere Studio
Tutorial: Managing Databases with Sybase Central
Sybase Central includes a set of database utilities for carrying out common database administration tasks. Wizards walk you through the steps involved.
To see a list of those utilities that can be used on a running database, right-click on the sample database container. Several options appear on the popup menu, including Backup Database, Upgrade Database, and Validate Database. Each of these menu items represents a utility.
In this section, we use a wizard to back up the sample database. This can be done on a running database.
To back up a running database
In the left pane, right-click the asademo - DBA icon and choose Backup Database from the popup menu. The Backup Database wizard appears.
Read the introductory page of the wizard and click Next.
Select asademo from the list of databases you can back up. Click Next.
Select On Disk, In The Following File.
Type a filename in the text box indicating where you want to back up the database to. As this is a tutorial, you may wish to choose a file in a temporary directory such as c:\temp\backup.
Click Finish to back up the database.
This kind of backup is called an archive backup. You can also make backups called image backups, which are physical copies of the database file and associated files. For more information, see Types of backup.
An extension of .1 is added to the filename you specify in the Backup Database wizard.
Wizards are available for several other database administration tasks. You may wish to try creating a database by right-clicking the server in the left pane and choosing Create Database from the popup menu.