First Guide to SQL Anywhere Studio
   PART 2. Getting Results with SQL Anywhere Studio
     CHAPTER 4. Managing Databases with Sybase Central       

Backing up a database using Sybase Central

Sybase Central includes a set of database utilities for carrying out common database administration tasks. Wizards are provided to help carry out the task step-by-step.

To see all the database utilities provided with Sybase Central, click the Database Utilities folder at the top of the left panel. A list of the utilities appears in the right panel.

Some of the utilities are used on database files, while others can be used with running databases. Those utilities that can be used on a running database are shown on a pop-up menu by right-clicking on the database icon. In this lesson, we back up the sample database.

  To back up a running database

1. Using the right mouse button, click the sample database and select Backup from the pop-up menu. The Backup Wizard appears.

2. You do not need to alter anything on the first page of the wizard. Click Next to move to the second page.

3. Type a directory in the text box indicating where you wish to back up the database to. As this is a tutorial only, you may wish to choose a temporary file directory such as c:\temp.

4. Check the Main Database File and Transaction Log File options, and uncheck the Database Write File option. Then click Next to take you to the next page of the Wizard.

5. Select the option Continue To Use The Original Transaction Log from the three options presented, and click Next to take you to the next page of the Wizard.

6. Review the choices you have made, and click Finish to back up the database. A window displays the progress of the backup.

Wizards are available for several other database administration tasks. You may wish to try creating a database by selecting the Database Utilities folder in the left panel and then double-clicking the Create Database tool in the right panel.