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 starting point for performing a restore. The Tools page should only be used by experienced users or with the assistance of BackupAssist 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 a 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 credentials.

  9. Select Type
  10. This step determines the type of database that will be restored: a user database or a master database. 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 add or confirm the location of your SQL database backups. If a backup is not listed, use the Browse field to type in the path of the backup or browse to it, then click Add. Confirm that the backups you need are listed 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 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.