Create a script to backup a remote SQL Server installation
You can use the NetBackup MS SQL Client to create a script to back up 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 create a script to backup of a remote SQL Server installation
- Select the host and instance you want to access.
- Select File > Backup SQL Server objects.
- Select the options for the operation.
Save is enabled in the backup dialog box. Launch immediately is disabled because the generated script must be run on the remote host that you are logged on to.
- Click Backup.
- 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.
- Launch the backup operation.
Do one of the following:
Run the operation from the local installation of NetBackup for SQL Server.
Create a new policy that includes the remote SQL Server client. Add the batch file to the Backup selections list in the policy.