Considerations

Review the following considerations before performing the Point-In-Time restore:

• You must manually enable Point-In-Time recovery while creating a backup plan for SQL Server before you perform the backup job from UDP Console.
• You must have two recovery points working together to perform Point-In-Time restore.
• Point-In-Time restore supports only the Agent Based backup. Host Based backup is not supported.
• Point-In-Time supports restore to original location only. Restore to alternate location and dump to disk are not supported.
• The backup of SQL Database Transaction Log is saved to the same directory of SQL Log File before taking the snapshot.
• The first recovery point provides the SQL Database level restore. After Point-In-Time restore, SQL Database is set to recovering state. You can back-up the recovery point in Point-In-Time disabled mode.
• To perform Point-In-Time restore, you must select the time point between N and N+1 recovery points. Any time point prior to N recovery point and after N+1 recovery point is not allowed. If you set the time point that is not between N and N+1 recovery point, the restore job fails and causes the database corruption.