SQL Restore Options (General)

Use this dialog box to control how the specified data is to be restored.

Note that restore options vary for single and multiple database restore jobs. The differences are noted below:

Destination Server

Displays the name of the instance to which the selected data will be restored. To restore a database to the same location on a different destination server, select another SQL Server from the list. This list includes SQL Servers in the CommCell which have the SQL Server Agent installed.

Source Server

Displays the name of the source server or database, depending on whether an instance or database was selected for restore.

Database Name

Displays the name of the database selected for restore.

Database List

Displays the names of the databases selected for restore if there is more than one such database.

Database State

Displays the current state of the server or database, depending on whether an instance or database was selected for restore.

Restore Time and Time Zone

Specifies the restore time depending on the selected options:

• For a multiple database or a full instance restore, this option indicates the time to which you want to restore all selected databases.

• For a single database restore, this option is displayed as a list of available backups from which you can select to restore.

• For a SQL Step Restore, this option is displayed as a list of available transaction log backups from which you can select a single log for restore.

Point-in-time

Specifies that the restore operation must restore single or multiple databases to the selected date and time.

• Restore Time

Provides a space for you to enter the date and time. Click the arrow to display a calendar.

• Time Zone

Lists the time zones. To change the time zone, select one from the list.

• Stop at mark

  Restores data to the selected transaction mark. This option is displayed when Transaction Log Marks check box is selected on the Options tab ofthe Advanced Restore Options dialog box.

  After restoring database to a selected transaction mark, the subsequent backup job for that database is automatically converted to a full backup.

• Stop before mark

  Restores data to a previous transaction mark. This option is displayed when Transaction Log Marks check box is selected on the Options tab ofthe Advanced Restore Options dialog box.

  After restoring database to a previous transaction mark, the subsequent backup job for that database is automatically converted to a full backup.

Recovery Types and Undo Path

Specifies the type of recovery that must be performed. This is the state of the database after the restore.

• Recovery

  Selecting this option to restore a database leaves the database in an online state.

• Norecovery

  Selecting this option to restore a database leaves the database in a restoring state.

• Stand By

  Selecting this option to restore a database leaves the database in a read-only state.

• Undo File Path

  Displays the path in which the undo file is stored, when the Recovery Type is Stand By. Use the space to modify the default path.

  Once the restore is complete, the SQL Server Agent will use the data from the undo file and the transaction log to continue restoring the incomplete transactions. Hence, once the restore completes, the undo file will be re-written with any transactions that are incomplete at that point.

• Browse

  Click to select a path for the Undo File Path.

Restore Options

• Unconditionally overwrite existing databases or files

  Select this option to restore a database to the same location from where it was backed up. When this option is selected, the data being restored is unconditionally written to the specified location and will overwrite the files of any other database that is currently using the database name specified by you.

  When this option is not selected, restore prevents accidental data files overwrite by failing the job.

• Preserve Replication Settings

  Specifies to restore backups of replicated databases. SQL Server replication allows distributing data to various servers throughout an organization. A published database can be restored to a server other than the server where the database was created. This is relevant only to full backups and if the database was part of a replication implementation. This option is available only when the Recovery type option is selected.

  Back up the following replicated databases and their associated system databases regularly:

  • The publication database at the Publisher

    The master and msdb system databases at the Publisher and the publication database must be backed up at the same time.

  • The distribution database at the Distributor

    The master and msdb system databases at the Distributor and the distribution database must be backed up at the same time.

  • The subscription database at each Subscriber

    The master and msdb system databases at the Subscriber and the subscription database must be backed up at the same time.

  Ensure that after the restore operation, the master and msdb databases are consistent with the associated system database in terms of replication configuration and settings.

  For backups and restores recommendations and strategies, refer to the Microsoft article Backing up and Restoring Replicated Databases.

• Keep Change Data Capture

  Specifies to restore SQL 2008 or later databases, if they were backed up with the Change Data Capture property enabled. This property provides the ability to query a database for changed data. This is a useful SQL feature in that all change activity (insert, update, and delete) is captured and applied to SQL tables. The details of the changes are available in an easily consumed relational format. This option does not apply to backups that were VSS-enabled or to IntelliSnap backups.

Database

Displays the name of the database to be restored. You can change the database name here to restore the database to a different location on the same server.

File Name

Displays the name of the file in which the selected database to be restored is present.

Physical Path

Displays the path of the database and the log files. You can change the database path here to restore the database to a different location.

Notes:

• If there are many files, use the Find & Replace option to enter the new destination path for all the files at once.

• If the database path is changed without changing the database name, the existing database will be overwritten and will point to the new location.

• If the same path in the destination server cannot be used for any reason, for example, if the destination server does not have the corresponding path, rename the database and change the database path.

Size

Displays the database size.

Analysis Server Options

• Allow Database Overwrite

  Select to allow Analysis Services to restore the contents of the selected backup file over any existing objects in the selected Analysis Services database.

• Include Security Information

  Select to copy any security information stored in the backup file to the Analysis Services database.

  • Copy All

    Restores the database roles contained in the backup file and the user accounts associated with the roles.

    Note: Select this option, if you are restoring the Analysis Services databases on Tabular mode.

  • Skip Membership

    Restores the database roles contained in the backup file, but does not restore the user accounts associated with the roles.

• Restore Remote Partitions

  Select to restore remote partitions stored in remote backup files. This option is enabled only if the backup file contains references to remote partitions.

Advanced

Click to select additional restore options.

Save As Script

Click to open the Save As Script dialog box, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be executed from the Command Line Interface using the qoperation execute command.

When you save an operation as a script, each option in the dialog has a corresponding XML parameter in the script file. When executing the script, you can modify the value for any of these XML parameters as needed.

To view the XML values for each of the options in the dialog, see the following:

Command Line XML Options

SQL Instant Clone

Use this dialog box to specify the instant clone options.

Destination Server

Displays the name of the instance to which the selected data will be restored. To restore a database to the same location on a different destination server, select another SQL Server from the list. This list includes SQL Servers in the CommCell which have the SQL Server Agent installed.

Snap Mount Path

The path where the software mounts the snapshot

Overwrite if clone exists

Select this check box to have the software clean up any existing clone on the destination, regardless of the reservation period.