The Backup utility
78
The Backup utility
With the Backup utility, you can back up running databases, database files,
transaction logs, and write files.
You can access the Backup utility in the following ways:
♦ From Sybase Central
♦ From the system command line, using the
dbbackup
utility. This is
useful for incorporating backup procedures into batch or command files.
The Backup utility makes a backup copy of all the files for a single database.
A simple database consists of two files: the main database file and the
transaction log. More complicated databases can store tables in multiple
files, with each file as a separate dbspace. All backup filenames are the same
as the database filenames.
Running the Backup utility on a running database is equivalent to copying
the database files when the database is not running. Thus, you can back up
the database while other applications or users are using it.
$ For a description of suggested backup procedures, see "Backup and
Data Recovery" on page 645 of the book ASA User’s Guide.
$ For more information about the backup utility, see "BACKUP
statement" on page 401.
Backing up a database from Sybase Central
v To back up a running database:
1 Connect to the database.
2 Right-click the database and choose Backup in the popup menu. The
Backup wizard appears.
3 Follow the instructions in the wizard.
v To back up a database file or a running database:
1 Open the Utilities folder in the left panel.
2 Double-click Backup Database in the right panel.
3 Follow the instructions in the wizard.
To Next Page
Loading...