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.
Contents
To restore from backup
- 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.
- Select Utilities > Database Restore. The Recovery Wizard opens.
- Use the topics below as a guide to providing information as you walk through the pages of the wizard:
- 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. |