User's Guide

Part II. Tutorials

Chapter 4. Managing Databases with 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 mouse 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. You should already have the user ID DBA filled in, together with the password. Click Next to move to the next page of the wizard.
4. 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.
5. 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.
6. Select the bottom option button from the three options presented, and click Next to take you to the next page of the Wizard.
7. 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.