To restore backup files to a different server to a point in time, please follow the steps below:
1. Open the SQL Backup GUI.
2. Run the Restore Wizard. In step 1 of the Restore wizard (Select backups to restore), change the drop down box from 'select from backup history' to 'Browse for backup files to restore'. The appearance of the dialog box will change.
3. Still on Step 1, click the 'Add files' button.
4. Browse to locate the backup files you wish to restore. You can choose multiple files.
5. In the background the selected backup files are checked to ensure that they are valid, as confirmed by a 'tick' on a green circle. Now click OK. If the files are invalid there will be a 'X' on a red circle.
6. Step 2 of the Restore Wizard appears. By default the wizard selects the option to 'Overwrite existing database'. As the database you wish to restore too may not be listed, you can select the second option to 'Create new database' and enter the database name.
7. In the Filegroups and files section, modify the locations for the Primary, Transaction Log and if configured the filegroups as required. Click Next.
8. Step 3 of the wizard appears. Confirm the 'Recovery completion state'.
9. Still on Step 3, as you wish to restore to a point in time, enable that option and configure the desired time and e-mail notification if so desired. Click Next.
10. The final step, step 4 appears. Review the summary to ensure what you wish to be restored is correct. Go back to the relevant step if any changes are required. You can also select the Script tab to review the T-SQL commands that SQL Backup will use to perform the Restore. When you are happy, Click finish.
I hope the above helps.
I have also answered the support ticket you submitted.
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal