X hits on this document

554 views

0 shares

0 downloads

0 comments

115 / 200

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

1

Select the host and instance you wish to access. Refer to “Selecting the SQL host and instance” on page 63.

2

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.

3

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.

4 5

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.

6

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.

115

Document info
Document views554
Page views554
Page last viewedSat Dec 10 13:31:22 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments