You are here: Microsoft SQL Protection > Restoring SQL backups > Restoring SQL full backups

Restoring SQL full backups

A SQL full backup of a user database may be restored to any available SQL server that has been added as a client to the Unitrends system. The database may also be renamed and restored to a specified alternate path if desired.

Note:  This procedure is for full backups of user databases only. If you would like to restore a system database, see Restoring the master database or Restoring the model and msdb databases.

To restore a SQL full backup

1 Select a SQL icon in the Navigation pane and click Restore.
2 Select a Recovery Point Day from which the backup will be restored by clicking on the calendar. Available days display in bold.
3 Select a full backup of a user database from the Recovery Point Times list. Hover your mouse over the names of the databases to see the backup type.
4 Select one of the following:
• Click Next (Select Options) if you wish to restore the single database selected.
• Click Select Multiple Databases if you wish to restore more than one database. Check boxes to select the desired databases, then click Confirm.
5 From Available SQL Servers, select the SQL server you want to restore to.
6 From Select SQL Instance, select an available SQL instance. Available SQL instances are denoted with a green check mark.
7 (Optional) Type a new name for the database under Database Name. If you leave the database name the same, the restore operation overwrites the existing data. Changing the database name creates a new database on the SQL instance.
8 (Optional) Check the Specify Target Pathname? box and supply an alternate path.
• If restoring to an alternate SQL instance on the same SQL server and no alternate target pathname is specified, the files are restored to the default path of <Vol>:\UnitrendsRestore, where <Vol> is the volume on the client with the most free space.
• If restoring to an alternate SQL server, you must specify a pathname.
9 (Optional) Specify pre- and post-backup commands by clicking the Show Advanced Execution Options icon. For details see Backup options New and View/Modify buttons.
10 Click Restore. If you’re restoring to the original SQL server and did not specify a new database name, the Restore Confirmation dialog box displays informing you that restoring the database without changing the name will overwrite the existing database. Check the check-box and click Confirm.
11 Click Okay on the Restore Status dialog box. You can view the status of your restore by navigating to Settings > System Monitoring > Jobs. For details, see Monitoring running restore jobs.