Restoring SQL Databases

Restore data to its original location on the same computer by using the default values in the Restore Options dialog box. You can choose different combinations of restore options to perform different types of restores.

If you perform a restore from the instance level, all databases in that instance are restored in single restore job. If you perform a restore by selecting multiple non-system databases, the non-system databases are restored through multiple jobs.

If you are performing an in-place restore operation and you want to either overwrite an existing database or restore multiple backups of the same database, select the Unconditionally overwrite existing databases or files check box during the restore operation.

Procedure

  1. From the CommCell Browser, click Client Computers > client > SQL Server.

  2. Right-click the instance, and then click All Tasks > Browse and Restore.

  3. In the Browse and Restore Options dialog box, click Advanced Restore, then click View Content.

  4. Select the data that you want to restore, and click Recover All Selected.

    The SQL Restore Options dialog box is displayed.

  5. On the General tab, choose how you want to restore the data.

    For more information about general restore options, see SQL Restore Options (General).

  6. On the Job Initiation tab, choose whether to run the restore job immediately or on a schedule.

  7. Optional: To further customize the restore operation, click Advanced.

    The Advanced Restore Options dialog box appears.

    Goal

    Action

    Restore transaction marks in the transaction log

    On the Options tab, select Transaction Log Marks.

    Restore only the last full backup of a database

    On the Options tab, select Full Backup Only.

    Restore a database with restricted user access

    On the Options tab, select Leave Database in Restricted User Mode.

    Restore a database without exclusive access

    On the Options tab, select Drop Connections to Database.

    Restore databases to a disk

    On the Options tab, select Restore to Disk.

    Restore the IntelliSnap or VSS-enabled backups to disk

    On the Options tab, select Restore to Disk, and then select Attach to SQL Server to attach the database files.

    Run a restore validation job

    On the Options tab, select Verify Only, and then click OK in the Information dialog box.

    Run checksum validation during a restore operation

    On the Options tab, select Checksum.

    Ignore errors encountered during a restore operation and complete the job

    On the Options tab, select Continue After Error.

    Leave the database in restricted user mode

    On the Options tab, select Leave Database in Restricted User Mode.

    This option is only available if the bEnableAdvancedRestoreOptionsMSSql setting is set to "true".

    Preserve the replication settings

    On the Options tab, select Preserve Replication Settings.

    This option is only available if the bEnableAdvancedRestoreOptionsMSSql setting is set to "true".

    Keep the change data capture

    On the Options tab, select Keep Change Data Capture.

    This option is only available if the bEnableAdvancedRestoreOptionsMSSql setting is set to "true".

    Run a restore-related process before or after a restore operation

    Enter the path for the batch file in the Pre Recovery Command box or the Post Recovery Command box. You can also click Browse to select a batch file to run a pre or post restore process.

  8. Optional: Run your restore operations from a command line interface. Click Save as Script.

    For more information, see Command Line Interface.

  9. Click OK.

If you selected to run the restore job immediately, you can monitor the progress of your restore job in the Job Controller window. For more information, see Job Controller.

After the restore job is complete, you can view the restore job history. For more information, see Job History.

Loading...