Select Backups

This topic describes the Restore wizard page for selecting the database that you want to restore, and the backup files to use.

Choose:

• Select from backup history to select from a list of backups.
• Browse for backup files to restore to select individual backup files using the file selector.
  

Select from backup history

Select the SQL Server and Database that was backed up.

The backups for the selected database are listed. Select the backup you want to restore. (Note that backups that were created using earlier versions of SQL Backup Manager are not listed; you can use Browse for backup files to restore to select these files.)

If you select a files or filegroups backup, you can select individual files or filegroups to restore at a later stage in the wizard.

When you click Next, SQL Backup Manager retrieves the files for the selected backup. If you selected a transaction log backup or a differential backup from a backup set, SQL Backup Manager automatically retrieves files for all backups in the set. For example, if you selected a transaction log backup, SQL Backup Manager retrieves all transaction log backups since the corresponding full backup, and the full backup itself.

The files are listed with the most recent first. You can reorder the list by clicking the column headers as required; this will not affect the order in which they will be restored.

is displayed next to any encrypted files. Click Enter Password, and type the password. For all files that use the password you entered, is displayed. You must enter the passwords for all selected files before you click Next.

If there are any problems with a file, is displayed next to the file. For example, SQL Backup Manager checks that all the files exist and are not corrupted. To see details of the error, move your mouse pointer over the icon.

By default, all the files that SQL Backup Manager has identified as part of the backup set are selected to be restored. If required, you can clear the Restore check box for a file. For example, you may want to do this if you know that the full backup has already been restored to a database. However, note that the restore process may fail if you do not restore all required files.

Browse for backup files to restore

Select the SQL Server on which you want to search for backup files, and click Add Files. The file browser is displayed for you to select the backup files. When you click OK on the file browser, the files you have selected are listed.

is displayed next to any encrypted files. Click Enter Password, and type the password. For all files that use the password you entered, is displayed. You must enter the passwords for all selected files before you click Next.

If there are any problems with a file, for example if it is corrupted, is displayed. To see details of the error, move your mouse pointer over the icon.

If there are any problems with your selection, for example if you have selected backup files from different backup sets or databases, a message is displayed above the list of files.

SQL Backup Manager displays only one message at a time, therefore when you have fixed the displayed problem, you may see a second message.

To remove a file from the list, select the file and click Remove; to clear the list, click Remove All.