Restore Transaction Log (Options Page)

Use the Options page to specify additional options for restoring a transaction log.

To restore a transaction log by using SQL Server Management Studio

Note

When you specify a restore task by using SQL Server Management Studio, you can generate the corresponding Transact-SQLRESTORE script by clicking the Script button and then selecting a destination for the script.

Options

  • Preserve replication settings
    Preserves the replication settings when restoring a published database to a server other than the server where the database was created.

    This option is available only with the option Leave the database ready for use by rolling back the uncommitted transactions (described later in this table), which is equivalent to restoring a backup with the RECOVERY option.

    Selecting the Preserve replication settings option is equivalent to using the PRESERVE_REPLICATION option in a Transact-SQL RESTORE statement.

  • Prompt before restoring each backup
    Asks you for confirmation before restoring each backup set.

    This option is particularly useful when you must swap tapes for different media sets, such as when the server has one tape device.

  • Restrict access to the restored database
    Makes the restored database available only to the members of db_owner, dbcreator, or sysadmin.

    Selecting this option is equivalent to using the RESTRICTED_USER option in a Transact-SQL RESTORE statement.

  • Leave the database ready for use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH RECOVERY)
    Recovers the database. This option is equivalent to the RECOVERY option in a Transact-SQL RESTORE statement.

  • Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY)
    Leaves the database in an unrecovered state. This option is equivalent to using the NORECOVERY option in a Transact-SQL RESTORE statement.

    When selecting this option, the Preserve replication settings option is unavailable.

  • Leave the database in read-only mode. Undo uncommitted transactions, but save the undo actions in a file so that recovery effects can be reverted. (RESTORE WITH STANDBY)
    Leaves the database in a standby state. This option is equivalent to using the STANDBY option in a Transact-SQL RESTORE statement.

    Choosing this option requires that you specify a standby file.

  • Standby file
    Optionally, specify a standby file name in the Standby file text box. This option is required if you leave the database in read-only mode.