SQL differential and transaction backups must be restored to the original server and instance. When restoring a SQL differential or transaction backup, all previous backups in the group are restored sequentially. This means that when restoring a transaction backup, all previous transaction backups, the latest differential (if any), and the parent master are also restored. Each backup will be restored separately, and these backup jobs are queued automatically.
This procedure is for differential and transaction 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.
Important! If you are protecting your SQL client with Unitrends release 8.0 or higher, your differential backups must be restored to a server with an agent version of 8.0 or higher.
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 differential or transaction 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 (version 7.5 and higher). Check boxes to select the desired databases, then click Confirm.
5 (Optional) If restoring a transaction backup and you wish to restore to a point-in-time shortly before the time of the backup, check the Restore To Point-In-Time check-box. Read the alert, and click Okay. Click the arrow on the slider and drag it to the desired time. This feature is not available for differential backups.
6 (Optional) Type a new name for the database under Database Name.
Warning: If you leave the database name the same, the restore operation will overwrite the existing data. Changing the database name will create a new database on the SQL instance.
7 (Optional) Check the Specify Target Pathname? check box and supply an alternate path. By default, databases are restored to their original location. If restoring to an alternate SQL server, you must specify a pathname.
8 (Optional) Specify pre- and post-backup commands, click the Show Advanced Execution Options icon. For details see Backup options new and view/modify buttons.
9 Click Restore. If you 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.
10 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.