To perform backups and restores of remote SQL Server installations

1. Select the host and instance you want to access.

2. Create the backup or restore script.

   Select one of the following:

   • To create a backup script, select File > Backup SQL Server objects.

   • To create a restore script, select File > Restore SQL Server objects.

3. Select the options for the operation.

   Save is enabled in the backup and restore dialog boxes. Launch immediately is disabled because the generated script must be executed on the remote host that you are logged on to.

4. Click Backup or Restore.

5. In the Save Script As dialog box, navigate to the install_path\NetBackup\DbExt\MsSql\ folder on the remote host, and save the batch file there.

6. Launch the backup or restore operation.

   Do one of the following:

   • Run the operation from the local installation of NetBackup for SQL Server.

   • Create a new policy and add the batch file to the Backup Selections list in the policy.