Legacy SQL Server point in time restore

The point-in-time restore allows you to restore a database to a given point in time. In order to perform a point-in-time restore for a database, the recovery model for that database must be of type Full. This model type maintains the transaction logs for that database. At the time of profile creation using the SQL agent, you can select the point-in-time restore option. With this option selected the transaction log backups are performed by default.

For a point-in-time restore through the SQL agent, you are required to provide the time up to which the database is to be restored. If there are any valid backups performed before the given time, the restore is queued to the server once the job is submitted. If there are no valid backups before the given time an error message is displayed to check the available backups for the particular database. The exact time of backups can be seen using the Backup Times button. This helps you know the exact time to which you can recover the database. When a restore job for the SQL database is submitted, the closest full backup, differential backup, and all transaction logs within the point-in-time gets queued to the server. Enter the desired options in the SQL agent restore interface to perform a point-in-time restore.

Note: The point-in-time option is only available for restoring a single database.