Using NetBackup for SQL Server Performing backups and restores of remote SQL Server installations
Note: All of the keyword-value pairs in this section are only permitted in the first operation of the batch file.
Performing backups and restores of remote SQL Server installations
You can use NetBackup for SQL Server to backup and restore databases on a remote host. Generated batch files must be saved on the remote host. You can launch the operation from the local installation of NetBackup for SQL Server, from an automatic backup policy, or from a manual backup.
To perform backups and restores of remote SQL Server installations
Select the host and instance you wish to access. Refer to “Selecting the SQL host and instance” on page 63.
Create the backup or restore script.
To create a backup script, choose File > Backup SQL Server objects.
To create a restore script, choose File > Restore SQL Server objects.
Select the desired options for the operation.
See “Backup options” on page 65 or “Restore options” on page 77 for a description of the available options.
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.
Click Backup or Restore.
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.
To launch the backup or restore operation:
Run the operation from the local installation of NetBackup for SQL
Server. See “Running batch files” on page 114. OR
Create a new policy and add the batch file to the Backup Selections list
in the policy. See “Configuring a backup policy for a database” on page 27.