Database Backup (SYB ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Database Backup

This wizard lets you generate and execute DUMP DATABASE or DUMP TRANSACTION commands.

To create a database backup

  1. Connect to the datasource where the database to be backed up is located and ensure that it is the selected datasource. For details, see Connected/Selected Datasource options.
  2. Select Utilities > Database Backup. The Backup Wizard opens.
  3. The options offered depend on the sections you make as you progress through the pages of this wizard. Use the following table as a guide to providing details as you pass through the pages of the wizard.

New Backup Operation

Select to define a new backup operation.

Previous Backup Operation

Select to open a previously defined backup operation and use the associated controls to provide the location and name of the job file.

What are the source Sybase server and database?

Select a server from the drop-down list and then the appropriate datasource.

What do you want to dump?

Database - Backs up the entire database. The size of the database is listed in parentheses. Transaction Log - Backs up the inactive portion of the transaction log. The size of the transaction log is listed in parentheses. Transaction Log With No Log - Removes the inactive portion of the transaction log without making a backup of it. You should only use this command when you run out of room in the database and cannot issue DUMP TRAN WITH TRUNCATE_ONLY. Transaction Log With Truncate Only - Removes the inactive portion of the transaction log without making a backup of it. You should use this command prior to backing up a database. Transaction Log With No Truncate - Makes it possible to dump a transaction log even if the database is inaccessible. You can use this option when the data portion of your database is damaged and the transaction log resides on a separate device.

What type of dump device do you want to use?

Choose among tape device, disk device, or file. When you select file, you need to type the file’s name.

Where should messages about the dump operation be sent?

Your options are the Operator Console, Client, or Default.

Dump file

It’s up to you to specify the name of the dump file.

What dump devices do you want to use?

Lets you select from available devices.

Do you want to specify any device handling options?

Lets you provide retention time and compression level details. If you selected a tape device, rewind and dismount options are provided.

Do you wish to re-use this dump operation?

To re-use the operation, type the location and name of the definition file or click the browse button to find the file. DBArtisan gives the operation a default extension of *.dbdump.

4. Review the data unload operation description to verify its accuracy. If you need to make any changes, click Back to scroll back to the appropriate panels of the wizard to make your corrections. When ready, click Execute.