Specify the Recovery Point and Microsoft SQL Server Database

Use the Browse Recovery Points option to restore from a recovery point. When you select a recovery date, all the associated recovery points for that date are displayed. You can then browse and select the Microsoft SQL Server database to be restored.

Follow these steps:

  1. Access the restore method selection dialog in one of the following ways:
  2. From Arcserve UDP Console:
    1. Log into the Arcserve UDP Console.
    2. Navigate to resources > Node > All Nodes.
    3. All the added nodes are displayed in the center pane.
    4. Right-click the node, and then click Restore.
    5. You are automatically logged into the agent node console, and the Restore dialog opens.
  3. From Arcserve UDP Agent (Windows):
    1. Log into the Arcserve UDP Agent (Windows).
    2. On the home page, select Restore.
    3. The Restore dialog opens.
  4. On the Restore dialog, click the Browse Recovery Points option.
  5. The Browse Recovery Points page appears.
  6. Select the date for recovery from Recovery Point Date, the scheduled time for recovery from Time Range, select the Microsoft SQL Server database to be restored.
  7. The corresponding marker box becomes filled (green) to indicate that the database has been selected for the restore.
  8. Note: If you do not want the transaction log files to be applied after the restore, you must manually delete it before the restore is performed. For more information about manually deleting the transaction log files, refer to the Microsoft SQL Server documentation.

  9. Click Next.
  10. The Restore Options dialog opens.