Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide
- Introducing NetBackup for SQL Server
- Installing NetBackup for SQL Server
- Instance Management for SQL Server Intelligent Policies
- Viewing the SQL Server instances and instance groups in instance management
- About registering SQL Server instances
- 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 in high availability (HA) environments
- About using NetBackup to protect SQL Server availability groups
- 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
- About NetBackup for SQL Server with database mirroring
- Backup and recovery concepts
- Overview of SQL Server backup and recovery concepts
- About recovery factors for SQL Server
- Using NetBackup for SQL Server with multiple NICs
- Configuring backups with legacy SQL Server policies using clients and batch files
- About using batch files with NetBackup for SQL Server
- About schedule properties
- Backing up read-only filegroups
- Performing user-directed operations with dbbackex
- Using bplist to retrieve a list of SQL Server backups
- SQL Server backups and restores in an SAP environment (legacy SQL Server policies)
- About SQL Server backups and restores in an SAP environment
- 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
Configuring mappings for restores of a distributed application, cluster, or virtual machine
This configuration is required for restores of a SQL Server cluster or a SQL Server availability group (AG). Configure these mappings in the Distributed Application Restore Mapping host property on the master server.
To configure mappings for restores of a distributed application, cluster, or virtual machine
- On the master server, open the NetBackup Administration Console.
- Select NetBackup Management > Host Properties > Master Servers.
- In the right pane, double-click on the master server.
- Select Distributed Application Restore Mapping.
- Click Add.
- Provide the name of the application host and the name of the component host.
Table: Example entries for SQL Server
Environment | Application host | Component host |
---|---|---|
FCI (cluster with two nodes) | Virtual name of the SQL Server cluster | Physical name of Node 1 |
Virtual name of the SQL Server cluster | Physical name of Node 2 | |
AG (primary and secondary) | WSFC name | Primary name |
WSFC name | Secondary name | |
AG with an FCI (primary FCI and secondary FCI) | WSFC name | Primary FCI name |
WSFC name | Secondary FCI name | |
Virtual name of the SQL Server cluster | Physical name of Node 1 | |
Virtual name of the SQL Server cluster | Physical name of Node 2 | |
VMware | VM display name, VM BIOS UUID, or VM DNS name (Primary VM identifier other than ) | Host name of the VM |