Recovery points are supported for the following backup types:
-
Block-level backups
-
IntelliSnap backups
-
IntelliSnap application-aware SQL Server backups
After you create recovery points, use this dialog box to do the following:
-
List the active recovery points.
-
Change the recovery point expiration date.
-
Open the Browse window and restore individual tables.
-
Delete a recovery point.
Database
The name of the SQL database that was selected for table restore operations.
Mount Host
The MediaAgent that was selected for table restore operations.
Mount Time
The time and date that the recovery point job was created.
Recovery Time
The date and time that the backup job was run (backup job reference time).
Expiration Date
The date that the recovery point expires. When the recovery point expires, the following happens:
-
For IntelliSnap, the snapshot is dismounted.
-
For block-level backups, the mount point is deleted.
If the status of the job is Ready, you can change the expiration date by right-clicking the job, and then selecting Set expiration date.
Status
The value in this column indicates which state the recovery point job is in.
-
In Progress: The recovery point is in the process of being created.
-
For IntelliSnap, the snapshot is mounted, and the logs are replayed.
-
For block-level backups, a dummy mount is created, the corresponding logs are copied to a temporary location, and then replayed.
The time that it takes to create the recovery point depends on the number of transaction logs that need to be replayed.
-
-
Ready: The recovery point is created and messages can be recovered.
Recovery Point Job ID
The job ID. This is the same value that appears in the Job Controller.
Browse
The Browse button is available when the status is Ready. When you click Browse, the Browse window appears so that you can select the messages that you want to recover.
Delete
The Delete button is available when the status is Ready. When you click Delete, the selected recovery point job is removed. Alternatively, you can select one or more jobs, right-click them, and then select Delete.
Refresh
Clicking the Refresh button updates the list of recovery points so that you can see whether the status of a recovery point has changed, or see if new recovery points have been created. In addition, when you refresh the list, any recovery points that have expired are removed from the list.
