Specifying the post-restore state of multiple databases

When specifying a multiple-database restore operation, you can choose the states that you want each of the databases to be left in after the restore operation finishes. See the following topics for more information:

If you are performing a single-database restore operation, see Specifying the post-restore state of a single database.

Specifying multiple-database recovery state from the SnapManager Restore tab

When using the SnapManager Restore tab to restore multiple databases, you use the Multiple Databases Restore Option dialog box to specify the states in which the databases are to be left after the restore operation finishes.

To specify database recovery states for a multiple-database restore operation started using the SnapManager Restore tab, complete the following steps.

Step

Action

Open the Multiple Databases Restore Options dialog box.

1
From the SnapManager Restore tab, open the Multiple Databases Restore Options dialog box.

Specify a multiple-database restore operation.
This is described in Restoring using the SnapManager Restore tab.

As described in Step 14 of that procedure, click Restore when you are ready to start the restore operation.
Result

The Multiple Databases Restore Options dialog box appears and prompts you to choose the post-backup state for the databases.

Specify the post-restore database state.

2
Select the state that you want the database to be left in after the restore operation finishes.

Leave databases operational. No additional transaction logs can be restored.
Leave databases nonoperational but able to restore additional transaction logs.
Leave databases read-only and able to restore additional transaction logs.
For descriptions of the database recovery states, see Understanding post-restore database recovery states.

If...

Then...

All the databases are to be operational

Leave the "Leave databases operational..." option selected.

All of the databases are to be nonoperational

Select the "Leave databases nonoperational..." option.

Some of the databases are to be operational, and other databases are to be nonoperational

Select the "Leave databases operational..." option.
In the database list in the middle of the dialog box, deselect any databases that are to be operational.

All the databases are to be read-only

Select the "Leave databases read-only..." option.

3
If you selected the "Leave databases nonoperational..." option or the "Leave databases read-only..." option, you must also specify the directory that contains the undo file.

You can either type the directory name in the Undo File box or click "..." to browse to the directory.

Confirm restore options.

4
Click to activate the Confirm Restore Options Selected tab.

Result

The Confirm Restore Options Selected tab displays the restore options currently in effect.

5
Review all of the restore options shown in the tab.

If you want to...

Then...

Modify any of the currently specified restore options

Click Cancel to close the dialog box.

Modify any restore options (as described in Restoring using the SnapManager Restore tab) before proceeding with the restore operation.

Proceed with the restore operation with the currently specified restore options

Click OK to close the dialog box.

Start the multiple-database restore operation.

6
Continue with Step 15 in the procedure described in Restoring using the SnapManager Restore tab.

Step	Action
Open the Multiple Databases Restore Options dialog box.
1	From the SnapManager Restore tab, open the Multiple Databases Restore Options dialog box. Specify a multiple-database restore operation. This is described in Restoring using the SnapManager Restore tab. As described in Step 14 of that procedure, click Restore when you are ready to start the restore operation. Result The Multiple Databases Restore Options dialog box appears and prompts you to choose the post-backup state for the databases.
Specify the post-restore database state.
2	Select the state that you want the database to be left in after the restore operation finishes. Leave databases operational. No additional transaction logs can be restored. Leave databases nonoperational but able to restore additional transaction logs. Leave databases read-only and able to restore additional transaction logs. For descriptions of the database recovery states, see Understanding post-restore database recovery states.
If...	Then...
All the databases are to be operational	Leave the "Leave databases operational..." option selected.
All of the databases are to be nonoperational	Select the "Leave databases nonoperational..." option.
Some of the databases are to be operational, and other databases are to be nonoperational	Select the "Leave databases operational..." option. In the database list in the middle of the dialog box, deselect any databases that are to be operational.
All the databases are to be read-only	Select the "Leave databases read-only..." option.
3	If you selected the "Leave databases nonoperational..." option or the "Leave databases read-only..." option, you must also specify the directory that contains the undo file. You can either type the directory name in the Undo File box or click "..." to browse to the directory.
Confirm restore options.
4	Click to activate the Confirm Restore Options Selected tab. Result The Confirm Restore Options Selected tab displays the restore options currently in effect.
5	Review all of the restore options shown in the tab.
If you want to...	Then...
Modify any of the currently specified restore options	Click Cancel to close the dialog box. Modify any restore options (as described in Restoring using the SnapManager Restore tab) before proceeding with the restore operation.
Proceed with the restore operation with the currently specified restore options	Click OK to close the dialog box.
Start the multiple-database restore operation.
6	Continue with Step 15 in the procedure described in Restoring using the SnapManager Restore tab.

Specifying multiple-database recovery state from within the Restore Wizard

When using the Restore Wizard to restore multiple databases, you use the Database State After the Restore screen to specify the state that you want the database to be left in after the restore operation finishes.

To specify the database post-restore state for a multiple-database restore operation started using the Restore Wizard, complete the following steps.

Step	Action
Open the Database State After the Restore screen.
1	Step through the Restore Wizard screens, specifying a multiple-database restore operation, until you reach the Database State After the Restore screen. This is described in Restoring using the SnapManager Restore Wizard. Step 6 of that procedure lists the names of the Restore Wizard screens. Result The Database State After the Restore screen prompts you to choose the post-backup state for the databases.
Specify the post-restore database state.
2	Select the state that you want the database to be left in after the restore operation finishes. Leave databases operational. No additional transaction logs can be restored. Leave databases nonoperational but able to restore additional transaction logs. Leave databases read-only and able to restore additional transaction logs. For descriptions of the database recovery states, see Understanding post-restore database recovery states.
	If...	Then...
	All the databases are to be operational	Leave the "Leave databases operational..." option selected.
	All of the databases are to be nonoperational	Select the "Leave databases nonoperational..." option.
	Some of the databases are to be operational, and other databases are to be nonoperational	Select the "Leave databases operational..." option. In the database list in the middle of the dialog box, deselect any databases that are to be operational.
	All the databases are to be read-only	Select the "Leave databases read-only..." option.
3	If you selected the "Leave databases nonoperational..." option or the "Leave databases read-only..." option, you must also specify the directory that contains the undo file. You can either type the directory name in the Undo File box or click "..." to browse to the directory.
4	To apply your settings and proceed to the next wizard screen, click Next. Result The Restore Wizard displays the Restored Database Name screen.
Finish specifying the single-database restore operation.
5	Continue with Step 6 in the procedure described in Restoring using the SnapManager Restore Wizard.

Specifying the post-restore state of multiple databases

Related topics

Specifying multiple-database recovery state from the SnapManager Restore tab

Result

Result

Specifying multiple-database recovery state from within the Restore Wizard

Result

Result