Database Restore (SQL SVR)

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:
   • Playback or New Operation
   • Database Selection
   • Recovery Completion
   • Backup and Media Set Information
   • Recovery Options
   • Recover Operation Summary
   • Action Selection
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.