Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide
- Introducing NetBackup for SQL Server
- Installation and host configuration
- Host configuration and job settings
- Managing SQL Server objects for use with SQL Server Intelligent Policies
- About discovery of SQL Server objects
- About registering SQL Server instances and availability replicas
- Registering instances or availability replicas with an instance group
- Configuring backups with SQL Server Intelligent Policy
- About tuning parameters for SQL Server backups
- Performing restores of SQL Server
- Redirecting a SQL Server database to a different host
- Protecting SQL Server data with VMware backups
- About protecting an application database with VMware backups
- Configuring backups with Snapshot Client
- Using copy-only snapshot backups to affect how differentials are based
- About SQL Server agent grouped backups (legacy SQL Server policies)
- Protecting SQL Server availability groups
- Protecting SQL Server availability groups with intelligent policies
- Protecting SQL Server availibility groups with legacy policies
- About protecting the preferred replica in a SQL Server availability group (legacy backup policies)
- About protecting a specific node in a SQL Server availability group (legacy backup policies)
- About protecting the preferred replica in a SQL Server availability group (legacy backup policies)
- Protecting SQL Server in a cluster environment
- Configuring backups with legacy SQL Server policies using clients and batch files
- About using batch files with NetBackup for SQL Server
- About schedule properties
- Performing user-directed backups of SQL Server databases
- Performing user-directed backups of read-only filegroups
- Using NetBackup for SQL Server with multiple NICs
- Performance and troubleshooting
- About debug logging for SQL Server troubleshooting
- About disaster recovery of SQL Server
- Appendix A. Other configurations
- About SQL Server backups and restores in an SAP environment
- Appendix B. Register authorized locations
Adding clients to a policy
The client list is the list of hosts on which your batch files are run during an automatic backup. A NetBackup client must be in at least one policy but can be in more than one.
For a NetBackup for SQL Server policy, clients you want to add must have the following items installed or available:
SQL Server
NetBackup client or server
The backup or restore batch files
Note:
Each batch file must be present on each client.
To add clients to a policy
- Open the policy you want to edit or create a new policy.
To access the Policy dialog box, double-click the policy name in the Policies list in the NetBackup Administration Console.
- Before you can add clients, you must select Clients for use with batch files on the Instances and Databases tab.
- Click the Clients tab and click New.
- Type the name of the client and select the hardware and operating system of the client.
If SQL Server is installed in a cluster, specify the virtual name of the SQL Server as the client name.
Note:
If you installed NetBackup on more than one node in the SQL Server cluster, you must perform additional configuration.
See Reviewing the auto-discovered mappings in Host Management.
See Configuring mappings for restores of a distributed applications, clusters, or virtual machines .
- Choose one of the following:
To add another client, click Add.
If this client is the last client you want to add, click OK.
- In the Policy dialog box, click OK.