Setting Up Pre-Processes and Post-Processes for SQL Server Restore Operations

You can run batch files or shell scripts before and after restore jobs.

Procedure

1. From the CommCell Browser, click Client Computers > client > SQL Server.

2. Right-click the instance, and then click All Tasks > Browse and Restore.

3. In the Browse and Restore Options dialog box, click Advanced Restore, then click View Content.

4. In the browse view, select the data that you want to restore, and click Recover All Selected.

   The SQL Restore Options dialog box appears.

5. Click Advanced.

   The Advanced Restore Options dialog box appears.

6. On the Pre/Post tab, make the following selections:

   1. To run a script before the software performs the backup operation, in the Pre Recovery Command box, type the full path to the script.

   2. To run a script after the software performs the backup operation, in the Post Recovery Command box, type the full path to the script.

   3. To run the post recovery command regardless of the job outcome, select the Run Post Restore Process for all attempts check box.

   4. Select one of the following connection options:

      • Use Local Accounts - Select this option if the local account has permissions to execute the processes on the destination client.

      • Impersonate User - Select this option and enter the credentials for a user that has the permissions to execute the processes on the destination client.

   5. Click OK.

7. Click OK.