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
Registering instances or availability replicas with an instance group
Instance groups provide the following benefits when you create SQL Server policies:
When you add an instance group to a policy, that single policy can back up many instances or availability replicas.
You can configure an instance group to automatically add newly discovered instances or replicas to the group, which are then registered on the fly.
See Registering instances or availability replicas automatically.
All the instances or replicas in the group use the same credentials setting. If you select the setting
, you only need to enter those credentials once.In the Applications utility, you can easily see which policies protect which instance groups.
To create an instance group
- In the NetBackup Administration Console, in the left pane, expand NetBackup Management > Applications > Microsoft SQL Server.
- Right-click Instance Groups and select New Instance Group.
- Provide an Instance Group Name.
- Select the credentials you want to use.
This user account must have certain privileges. More information is available to help determine which option best applies for your environment.
See About credentials used with SQL Server Intelligent Policy.
- Click OK.
- To add instances or replicas to the group you created, see the following topic.
See Adding an instance or availability replica to an instance group.