Restoring a Backup from Device 

Use

Use this procedure if your msdb database is not up to date and you therefore cannot perform a normal restore using the backup history.

Depending on the overall restore operation that has to be carried out, you may have to repeat the procedure described here several times or only once. In an operation where you fully restore the entire database, repeat the procedure for the database backup and all the succeeding transaction log backups.

If you only need to restore the final log backup from disk, and have already restored all other backups using the standard approach based on the backup history, take special care when setting the restore option. It must be set to Leave database operational. No additional transaction logs can be restored.

Procedure

  1. Insert the tape with the current backup into the tape drive.
  2. In the Enterprise Manager, select the R/3 database and choose Action ® All Tasks ® Restore Database.

    3. The Restore Database dialog box opens.

  3. Switch to the Options tab. Set the options:

    4. Force Restore over Existing Database

    Leave database nonoperational, but able to restore additional transaction logs

    Confirm your entry with OK.

    If the actual restore is the last in the overall restore process, set the restore option to:
    Leave database operational. No additional transaction logs can be restored

  4. Switch to the General tab. Specify that you want to restore From Device.
  5. Choose Select Devices.

    6. The Choose Restore Devices dialog box opens.

  6. Choose Tape and then Add.

    7. The Choose Restore Destination dialog box opens.

  7. Select the device where the tape with the backup is located. Confirm your selection with OK.

    8. The Choose Restore Device dialog box reappears.

  8. Again select the device where the backup is located and choose OK.

    9. The General tab reappears.

  9. Look at the contents of the tape. To do this, select the device and choose View Contents.

    10. The list of backups on the tape is displayed.

  10. Select the backup and confirm with OK.
  11. Choose Database - complete or transaction log
  12. On the general tab, check that the <SAPSID> database is specified. Start the restore operation with OK.

The current backup is restored from device.