Table of ContentsView in Frames

Specifying the post restore state of databases

When specifying database restore operation, you can select the states that you want each of the databases to be left in after the restore operation finishes.

Specifying database recovery state from SnapManager Restore

When using the SnapManager Restore option to restore multiple databases, you use the SnapManager for SQL Server-Restore 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 database restore operation started using SnapManager Restore, complete the following steps.

Step Action
Open the SnapManager for SQL Server-Restore dialog box.
1

In the Actions pane, click Restore.

Result The "SnapManager for SQL Server-Restore" dialog box appears and prompts you to select the post-backup state for the databases.

2

Select the databases to be restored from the list that appears. This is described in Restoring using the SnapManager Restore option in Performing a restore operation. As described in that procedure, click Restore when you are ready to start the restore operation.

Specify the post-restore database state.
3

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

  • Leave the databases operational. No more transaction logs can be restored.
  • Leave the databases nonoperational but able to restore more transaction logs.
  • Leave the databases read-only and able to restore more 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 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

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

All the databases are to be read-only

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

4

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.

Start the multiple-database restore operation.
5

Continue with the procedure described in "Restoring using the SnapManager Restore option" in Performing a restore operation.

Specifying database recovery state from within the Restore wizard

When using the Restore wizard to restore databases, you use the "Database state after 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 database restore operation, until you reach the "Database state after restore" screen.

This is described in "Restoring using the SnapManager Restore Wizard" in Performing a restore operation.

Result The "Database state after restore" screen prompts you to select 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 the databases operational. No more transaction logs can be restored.
  • Leave the databases nonoperational but able to restore more transaction logs.
  • Leave the databases read-only and able to restore more 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 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

  1. Select the "Leave databases nonoperational..." option.
  2. In the database list in the middle of the dialog box, clear 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 go to the next wizard screen, click Next.

Result The Restore wizard displays the "Restore Database As" screen.

Finish specifying the single-database restore operation.
5

Continue with the procedure described in "Restoring using the SnapManager Restore option" in Performing a restore operation.