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.

Source Instance

Displays the name of the source instance.

Destination Client

Displays the name of the client 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.

Note

SQL Server databases can be restored to servers with same or higher SQL Server versions installed on it.

Destination Instance

Displays the name of the instance to which the selected data will be restored. To restore to a different instance, select another instance from the list.

Database

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.

Notes

  • In order to restore a database to a point in time, a transaction log backup must exist.

  • If a single database is restored, then the Restore Time selection changes from a list of available backups to selection boxes for date and time

  • If multiple databases are restored, then the Restore Time selection is already in the date/time selection format and clicking Point-in-Time accepts the selected date and time exactly as selected. If the restore time falls within the time span of a transaction log backup, the database is restored to the exact time indicated. Otherwise, the database is restored to the latest available backup prior to the selected time.

  • After running the point in time restore on a database, the subsequent backup job for that database is automatically converted to a full backup.

  • Restore Time

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

  • Client Time Zone

Displays the source client time zone. All the times listed are in the specified client time zone.

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 uses the data from the undo file and the transaction log to continue restoring the incomplete transactions. Therefore, once the restore completes, the undo file is 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 which it was backed up. When this option is selected, the data being restored is unconditionally written to the specified location and overwrites the files of any other database that is currently using the database name specified by you.

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

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.

Note

SQL Server databases can be restored to servers with similar or higher SQL Server versions installed on it.

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.

Loading...