Contents Index Edit stored procedure properties Restore the sample database

Introducing SQL Anywhere Studio
   Tutorial: Managing Databases with Sybase Central

Lesson 5: Back up your database


Sybase Central includes a set of database utilities for carrying out common database administration tasks. Wizards walk you through the steps involved.

Utilities 

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

  1. In the left pane, right-click the asademo - DBA icon and choose Backup Database from the popup menu. The Backup Database wizard appears.

  2. Read the introductory page of the wizard and click Next.

  3. Select asademo from the list of databases you can back up. Click Next.

  4. 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.

  5. Click Finish to back up the database.

Notes 

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.


Contents Index Edit stored procedure properties Restore the sample database