When it comes to restoring SQL databases, you have the option to restore just the (.bak) files or restore directly back into a running SQL instance. Keep in mind that, just like the backup jobs, you will need to have twice the size of the database(s) available, half of that for temporary files. This guide will outline the procedure for restoring SQL databases.
Restoring SQL Backup Files
Restoring the SQL backup (.bak) files allows you greater flexibility in how you choose to import SQL databases. Once restored, you can use the SQL backup files to restore to separate or multiple instances as well as specify how you want the restore to behave. The following procedure will let you restore the backup files.
Log into the management portal and navigate to the computer account on which you want to perform the restore.
Select the Restore tab and the Start a Restore button.
In the Restore window that appears, select Microsoft SQL as the data type and then hit Next.
The next page is where you will select which database and what revision to restore.
Click the arrow to the right of a SQL instance name to expand the list of databases available to restore, then click arrow to the right of a database name to expand the list of revisions available to restore.
Place a check mark in the box next to the revision you want and hit Next.
At the Settings page, specify a path for the destination; this is where the (.bak) files will be restored to. In the Restore DB section, leave the name field unchanged and hit Next.
On the final page you will be given a summary of the restore job you just created. If it appears to be what you want, hit the Restore button to begin the restore.
Restoring Into a SQL Instance
Restoring back into an active SQL instance can, currently, only be done in the backup software, not from the management portal. The instructions for doing so are as follows:
Open the backup software and click on the Restore tab at the top.
Under the Browse Remote Databases section, drill down to a SQL instance and the database you want to restore.
Clicking on the database in the left-hand pane should bring up a list of revisions in the right-hand pane; expanding a full backup revision will allow you to see the differential backups available to restore.
Select the revision you want from the right-hand pane and hit Restore.
In the Restore Database window, select a temp folder which has at least as much free space as the size of the database. Make sure the Verify DB Integrity option is checked and select a server to restore to; if you choose a different server than the one it came from, you may need to provide new authentication credentials. Click OK begin the restore.