Restoring a SQL Server Instance

Updated

On this page

You can restore an entire SQL instance, including system databases, to its original location on the computer.

This option restores databases to the same locations from which they were backed up. The data being restored is unconditionally written and overwrites the files of any other databases that are currently using the same database names. The instance is restored from the backup that you specify under Recovery Points and all connections to the databases are dropped to ensure exclusive access for the restore operation.

Databases which have been removed from the content of any of the SQL instance's subclients cannot be restored.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click the SQL instance that you want to restore.

  3. In the upper-right corner of the page, click , and then select Instance Recovery.

  4. A message confirming if you want to proceed with the recovery operation appears. Click Yes.