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
Prerequisites for protecting SQL Server availability groups
Before you configure policies to protect availability groups with legacy policies, review and complete the following prerequisites. Perform the steps after you create the SQL Server availability group.
See Table: Prerequisites for protecting the preferred replica in an availability group
Table: Prerequisites for protecting the preferred replica in an availability group
Step | Action | Description |
---|---|---|
Step 1 | Verify that you have a supported SQL Server configuration. | |
Step 2 | On each replica where you want backups to occur, install the NetBackup client. | |
Step 3 | On each replica where you want backups to occur, configure the NetBackup services. | See Configuring the NetBackup services for SQL Server backups and restores (legacy SQL Server policies) . |
Step 4 | Configure the mappings for distributed application restores. | For basic and advanced availability groups, map the WSFC (Windows Server Failover Cluster) name to each availability group node. If you have an availability group with an FCI, you must configure additional mappings. Configure these mappings in the Distributed Application Restore Mapping host property on the master server. See Configuring mappings for restores of a distributed application, cluster, or virtual machine . |
Step 5 | Review the auto-discovered mappings for the hosts in your environment. | Approve each valid that NetBackup discovers in your environment. Perform this configuration in the properties on the master server.See Reviewing the auto-discovered mappings in Host Management. |