Restoring a Database from Tape Streamer

This section tells you how to restore a database that has been backed up to tape using the standard database backup utility:

1. Create a batch file in the current directory, or in a directory that is included in your path, named as follows:

   • TAPERST.BAT for DOS, Windows and FlexOS
   • TAPERST.CMD for OS/2
   • taperst for UNIX

   Include the instructions that restore the database files from the tape streamer to your workstation. To make the batch file generic to any database, use the variable %1 in place of the database name.

   DP4 substitutes the name of your database in place of the variable when you run the database restore utility.

2. On the DP4 System menu, select the Run program option.

3. Type the command line:
   DBRESTOR -TAPE
   and press <Enter> to execute it.

4. The Database Restore utility screen is displayed. Select the database. DP4 prompts you to press any key when you are ready to restore the database.

5. The Database Restore utility runs the batch file TAPERST.BAT. The database name is substituted in place of the variable %1 in the batch file.

6. DP4 asks you if the database has been successfully restored. If you answer 'No' to this question, DP4 repeats the restore procedure. Answer 'Yes' to continue with the restore process.

7. The Transaction Log Recovery menu is displayed, and you are prompted to restore the transaction log as described earlier in Restoring a Database.

After restoring a database it is strongly recommended that you run the database integrity checking utility against it to ensure that you have a good database and complete working system.