Restore Database (Options Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Restore Database (Options Tab)

Use this tab to view or specify the following options.

Options

Eject tapes (if any) after restoring each backup

Eject tapes after restoring each backup.

Prompt before restoring each backup

Prompt the user before restoring each backup to prevent a user from inadvertently restoring a backup.

Force restore over existing database

Force the restore over an existing database.

Restore database files as

Specify the name and location of the database files that will be restored.

Leave database operational. No additional transaction logs can be restored

Leave the database operational, which means no additional transaction logs can be restored.

Leave database nonoperational but able to restore additional transaction logs

Leave the database operational but allow additional transaction logs to be restored.

Leave database read-only and able to restore additional transaction logs

Leave the database read-only and allow additional transaction logs to be restored.

Undo file

Specify the name of the file to undo. Click the browse (...) button to search for a file to undo.

See Also

Backing Up and Restoring Databases