After you use Hybrid Backup Recovery (HBR) to back up SQL Server databases to a backup vault, you can restore the databases to the source SQL Server instance or another SQL Server instance that uses the same backup vault.
Prerequisites
SQL Server databases are backed up. For more information, see Back up SQL Server databases.
Background
Before you restore SQL Server databases, note the following points:
- Currently, the restore paths of SQL Server databases cannot be modified. Therefore,
the paths of the destination SQL Server database on the destination SQL Server instance
must be the same as the default paths of the source SQL Server database on the source
SQL Server instance. If not, the restored SQL Server database cannot be loaded.
Note To view the default paths of an SQL Server database, you can open the Database Settings, and then view the paths of the SQL Server database in the Database default locations section.dialog box of the SQL Server instance, click
- If the source SQL Server database has more than one .ndf files, you can only restore this database to the destination database that has the same name. If not, the source database cannot be restored.
- When you restore an SQL Server database from incremental backup, HBR automatically uses full backup to restore the database before using incremental backup.
- To restore the databases of an SQL Server instance to another SQL Server instance, make sure that the version of the source SQL Server instance is not later than that of the destination SQL Server instance.
- To restore the primary database of an SQL Server instance, start the SQL Server instance in single-user mode.
Create a restore job
To create a restore job, perform the following steps:
What to do next
To view the status of restore jobs or cancel running restore jobs, perform the following steps:
- In the left-side navigation pane, choose SQL Server. . On the On-Premises Backup page, click
- Click the Restore Jobs tab.
- View the status of each restore job in the Status column.
- To cancel a running restore job, find the job and click Cancel in the Actions column.