Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide
- Introducing NetBackup for SQL Server
- Installing NetBackup for SQL Server
- Managing SQL Server objects for use with SQL Server Intelligent Policies
- About autodiscovery of SQL Server objects
- About registering SQL Server instances and availability group replicas
- Registering instances or availability replicas with an instance group
- Configuring SQL Server backups with SQL Server Intelligent Policy
- Configuring NetBackup for SQL Server
- Performing restores of SQL Server
- Redirecting a SQL Server database to a different host
- Restoring multistreamed SQL Server backups
- Protecting SQL Server data with VMware backups
- About protecting SQL Server data with VMware backups
- Using NetBackup for SQL Server 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
- Protecting SQL Server a log-shipping configuration
- SQL Server backups and restores in an SAP environment (legacy SQL Server policies)
- About SQL Server backups and restores in an SAP environment
- Backup and recovery concepts
- Overview of SQL Server backup and recovery concepts
- About recovery factors for SQL Server
- Troubleshooting
- About debug logging for SQL Server troubleshooting
- Disaster recovery of a SQL Server
- Appendix A. Sample batch files
- About sample backup batch files for legacy SQL Server policies
- About sample restore batch files
- About sample backup batch files for legacy SQL Server policies
- Appendix B. Multiplexed backups
- Appendix C. Register authorized locations
Registering a SQL Server instance or availability replica
To protect SQL Server with an Intelligent Policy, you must register the SQL Server instances or availability replicas with credentials. To protect an availability group, you may prefer to use an instance group to register one set of credentials for each of the replicas. Alternatively, you can register replicas individually if each replica requires different credentials.
Refer to Table: Options to register credentials to determine the best option for your environment.
For additional registration options, see the following topics:
See Registering instances or availability replicas with an instance group.
See Authorizing a DBA to register instances or availability replicas with the nbsqladm command.
To register a SQL Server instance or availability replica
- In the NetBackup Administration Console, in the left pane, expand NetBackup Management > Applications > Microsoft SQL Server.
- Select the instances or replicas, as follows:
To select instances, click All Instances.
The right pane displays a list of instances.
To select replicas, click Availability Groups > Availability group name.
The right pane displays a list of replicas for the availability group.
- Select the instances or replicas that you want to register. Instances or replicas that have previously been registered show a date and time in the Registered column.
- Choose Actions > Register.
For a SQL Server cluster, NetBackup adds a single entry or one instance in the Applications utility. The host for that instance is the virtual name of the SQL Server cluster.
- Select the credentials you want to use.
See About credentials used with SQL Server Intelligent Policy.
- Click OK.
If the validation fails, you can choose to save the instance or replica or enter different credentials. The backup of an instance or replica fails if the credentials are not valid for an instance or a replica.