SQL Point-in-Time restore

This section explains how to perform an SQL point-in-time restore using an SQL Server Protection backup. This restore option allows you to restore databases to a local or remote SQL Server. If the backup job used a transactional schedule, the databases can be restored to a specific point in time.

SQL point-in-time restore requires the SQL Continuous add-on license.

To perform an SQL point-in-time restore, start BackupAssist and follow these steps:

  1. Select the Restore tab
  2. The Restore tab has a Home page and a Tools page. The Home page is the default page and the recommended starting point for performing a restore. The Tools page should only be used by experienced users or with the assistance of technical support.

  3. Select SQL point-in-time
  4. This will open the SQL Restore tool and start the guided restore process. There is a Learn more about Restore link at the bottom of the screen.

  5. Select Server
  6. This step locates the SQL Server that you will restore to. You can select either a local or a remote SQL Server. Select the server to restore to and click Next.

  7. Server authentication
  8. When you select Next in the previous step, you will be prompted to provide credentials with access to the selected SQL Server. Enter the appropriate log on credentials.

  9. Select Type
  10. This step is used to identify the type of restore you want to perform. The restore of a selected user database or a master database restore, to recover the SQL Server. Make your selection and click Next.

  11. Select backup file
  12. If you selected Master database recovery, you will be asked to select a master database to restore from the list of backups with master databases .

  13. Master restore
  14. If you selected Master database recovery, you will be asked to start the master database restore and, when it has finished, continue with the other restore steps.

  15. Find backups
  16. This step is used to find or confirm the location of your SQL database backup files. Add or confirm the location of your SQL Server Protection backups, and click Next.

  17. Restore setup
  18. You will be presented with a list of databases that can be restored using the backups identified in the previous step. Select what databases to restore and what time to restore them from.

  19. Perform the restore
  20. Review the restore job settings and then select Start restore to the right of the window to restore all of the databases selected. Click Next once the restore process has completed.

  21. Perform full backup
  22. After restoring an SQL database, future transaction log backups cannot be used to restore a database to a specific point in time until a full backup runs. It is therefore recommended that you now run a full backup of the databases that were restored.

Your SQL Server Protection restore has now been completed.