Leaving the database in the roll-forward pending state

Use the Roll-Forward page of the Restore Database to New notebook to specify that you want to leave the database in the roll-forward pending state at the end of the restore operation.

Fields and controls

Authorities and privileges

To leave the database in the roll-forward pending state:

1. Open the Restore to New Database notebook.

2. On the Backup Image page, specify the backup image that you want to use to restore the database:

   • To use one of the backup images that are displayed, click on Select an entry from the list, then select the backup image that you want to use.

     If you have already created a backup image of the database from this administrative client, Select an entry from the list is preselected because the recovery history file for the database indicates that a backup image is available.

     If you know that the media type that is displayed for the backup image is not correct, then use the fields that are displayed under Change the media information if necessary to specify the correct media type for the backup image.

   • To use a backup image that is not displayed, click on Manually enter the backup image information. Use the fields that are displayed with Manually enter the backup information to specify the backup image that you want to use.

     If you have not already created a backup image of the database from this administrative client, Manually enter the backup image information is preselected because the recovery history file for the database does not contain any backup history for the database.

3. On the Description page:

   1. Type the name of the database that you want to create in the New database name field.

   2. Type the drive on which the database is to reside in the Default drive field. (For UNIX-based systems, this field is called Default directory.)

   3. Type an alias for the database in the Alias field.

   4. Type a comment for the database in the Comment field.

4. On the Roll-Forward page, ensure that the Leave in roll-forward pending state check box is selected.

5. Click on OK to create the database.

Related information

• Restore Database to New -- Overview