Database Restore (SYB ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Database Recover/Restore

This wizard lets you generate and submit a LOAD DATABASE statement, restoring a database and logs from tape, disk, or file.

To restore from backup

  1. Connect to the datasource where the database to be restored is located and ensure that it is the selected datasource. For details, see Connected/Selected Datasource options.
  2. Select Utilities > Database Restore. The Recovery Wizard opens.
  3. Use the topics below as a guide to providing information as you walk through the pages of the wizard:
  4. When ready, click Finish.

Playback or New Operation

Required Information Description

New Recovery/Load Operation

This initiates the process of creating a new recovery operation.

Previous Recovery/Load Operation

If you want to replay a recovery operation, when you select the radio button, the browse function is enabled so you can find the .sqrc file you want to reuse.

Database Selection for Sybase ASE

Here you select the Sybase server and database you want to recover from the drop-down lists.

Recovery Completion for Sybase ASE

Required Information Description

Which operation do you want to perform?

Load Database - Specifies that the complete database and transaction log should be restored. Load Transaction Log - Specifies that only the transaction log should be applied to the database. List Database - Validates a load database operation without actually performing the load. List Transaction Log - Validates a load transaction operation without actually performing the load.

Information type you want to see

Header Only, Brief Description, or Detailed Description.

If you are loading or listing a transaction log...

If you are loading the transaction log, in the If you are loading or listing a transaction log... box, type the specific log time you want to load.

Backup and Media Information for Sybase ASE

Required Information Description

What type of dump device do you want to use?

Choose among: Tape or Disk Device: Existing options for either of these choices become apparent on the next panel. If none are available, you won’t see any devices. File: You must type the name of the file you want use

Where should messages about the load operation be sent?

Select among: Default, Client, or Console.

Dump File

You must type the name of the file where you want to send the load operation messages.

Dump Device Selection for Sybase ASE

If you elected to use a tape or disk device, here you select which specific tape/disk device you want to use. You can choose one or more of the devices that appear in the panel. If none appear, you have to go Back to pick another device type. You can specify tape or disk properties by clicking each device, and then clicking the Attributes button. If you click Attribute, the Device Attribute Editor dialog opens.

Tape Handling Options for Sybase ASE

You can opt to dismount after the operation completes or rewind and unload after the operation completes.

Recovery Options

For MS SQL, the backup file is identified here, and if you are creating a new database from another database’s backup, you can rename files in the Recover As box.

For Sybase ASE, you see the default backup file, which you can easily change. You also have the option, for tape device operations, to load the data with decompression.

Recover Operation Summary

You can elect to save the recovery operation. You can see the default location where the recovery operation will be saved or you can browse to another location. The summary panel displays the choices you have made to this point. Go back to make changes.

Action Selection

Option Description

Open the recovery script in an ISQL editor

The recovery script will be opened into a new ISQL session. NOTE: This option is not available for Sybase ASE recoveries.

Perform the recovery now

The recovery will be executed immediately.

Schedule the recovery for later execution

The recovery will be scheduled to run at a specified date/time.