Please enter search query.
Search <book_title>...
NetBackup™ for Microsoft SQL Server Administrator's Guide
Last Published:
2024-09-30
Product(s):
NetBackup & Alta Data Protection (10.5)
- About NetBackup for SQL Server
- Installation
- Host configuration and job settings
- Installing the Veritas VSS provider for vSphere
- Configuring RBAC for SQL Server administrators
- Managing SQL Server assets and their credentials
- About discovery of SQL Server objects
- About registering SQL Server instances and availability replicas
- Configuring backups with SQL Server Intelligent Policy
- Performance tuning and configuration options
- Protecting SQL Server availability groups
- Protecting SQL Server availability groups with intelligent policies
- Protecting SQL Server availibility groups with batch file-based policies
- About protecting the preferred replica in a SQL Server availability group (batch file-based policies)
- About protecting a specific node in a SQL Server availability group (batch file-based policies)
- About protecting the preferred replica in a SQL Server availability group (batch file-based policies)
- Protecting SQL Server with VMware backups
- About protecting an application database with VMware backups
- Create a protection plan to protect SQL Server data with a VMware backup
- Configuring backup policies with Snapshot Client
- Using copy-only snapshot backups to affect how differentials are based
- About SQL Server agent grouped snapshots
- Protecting SQL Server in a cluster environment
- Managing protection plans for SQL Server
- Restoring SQL Server with the NetBackup web UI
- Using instant access with SQL Server
- Prerequisites when you configure an instant access SQL Server database
- Configuring batch-file based policies for SQL Server backups
- Requirements to use batch files with NetBackup for SQL Server
- Schedule properties for SQL Server batch file-based policies
- Configure a batch file-based policy for a user-directed backup of read-only filegroups
- Performing backups and restores with the NetBackup MS SQL Client
- Redirect a SQL Server database to a different host (NetBackup MS SQL Client)
- Restoring multistreamed SQL Server backups
- 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
- About NetBackup for SQL Server with database mirroring
- Appendix B. Register authorized locations
Add a batch file-based policy
This topic describes how to create a batch file-based policy that uses clients and batch files to perform backups.
Note:
To perform multistreamed backups and restores, or if you have multiple network interfaces, you need to perform other configuration.
To add a batch file-based policy
- Open the NetBackup web UI.
- Sign in to the primary server as a user that has the RBAC Administrator role or a role that can manage policies. If your site has more than one primary server, choose the one on which you want to add the policy.
- On the left, click Protection > Policies.
- Click Add.
- Type a unique name for the new policy.
- In the Policy type list, select MS-SQL-Server.
The database agent policy type does not appear in the list unless your primary server has a license for the database agent.
- Complete the entries on the Attributes tab.
- On the Instances and databases tab, select Clients for use with batch files.
The tab name changes to the name Clients. The Backup selections tab now lets you specify and browse for scripts.
Add other policy information as follows:
Add schedules.
Add clients.
Add batch files to the backup selections list.
- When you have added all the schedules, clients, and backup selections you need, click Create.