Restore - SQL Server iDataAgent

Deployment Deployment - Microsoft Cluster Deployment - Non-Microsoft Cluster Configuration Backup Restore

As restoring your backup data is very crucial, it is recommended that you perform a restore operation immediately after your first full backup to understand the process. The following sections explain the steps for restoring a user-created database to a different location on the same destination server.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server.
  2. Right-click the instance, and then click All Tasks | Browse and Restore.
  3. From the Restore Options dialog box, click the Time Range tab, and then click View Content.
  4. From the database list on the right, select the database you want to restore.
  5. Click Recover All Selected.
  6. From the SQL Restore Options dialog box, click the General tab.
  7. In the Database column, rename the database.
  8. In the Physical Path column, change the path of the database and log files.

  9. Click OK.
  10. You can track the progress of the job from the Job Controller window of the CommCell console.
  11. Once the restore job has completed, right-click the agent in the CommCell Browser and click View | Restore History.
  12. From the Restore History Filter dialog box, click OK to display the restore job history in a tab.
  13. You can right-click the job and view the following details:
    • View Restore Items

      You can view them as Successful, Failed, Skipped or All.

    • View Job Details
    • View Events of the restore job
    • View Log files of the restore job
    • View Job Path
    • Send Logs
    • Resubmit Job
  14. Once the database is restored, verify that the restored database and log files are available in the destination provided in the SQL Restore Options dialog box.

Congratulations -  You have successfully completed your first backup and restore.

If you want to further explore this Agent's features read the Advanced sections of this documentation.