Database Restore (SQL SVR)

From DBArtisan
Jump to: navigation, search

Go Up to Database Recover/Restore

This Wizard lets you build and submit a RESTORE statement, selecting a restore type as well as other options.

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

Required Information Description

Target Database

From the drop-down list, specify the target database for the recovery.

Restore Type

Elect to restore the database, filegroups or files, or a transaction log.

Backup Source

From Backup History - Find backup sets between the dates you specify and make your selection. From Device - Specify the device. Click Add or Edit to open the Recovery Wizard. Or, click Remove or Remove All to eliminate the device(s) from this operation.

Recovery Completion

Required Information Description

Leave database operational

No more transaction logs can be recovered.

Leave database non-operational

You can restore more transaction logs.

Leave database read-only

You can restore more transaction logs.

Force restore over existing database

Eject tapes (if any) after restoring each backup

Eject tapes after the backup is restored.

Point in time restore

Select the date and time from which you want the restore operation to take place.

Backup and Media Set Information

Here, for MS SQL, you specify the backup set name, backup set password, media name, and media name password. Any existing backup files are listed.

If you are creating at Leave database read-only operation, the Undo File option is enabled. Browse to find the file you want to undo.

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.