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
About configuring NetBackup for VMware backups that protect SQL Server
Table: Steps to configure VMware backups that protect SQL Server
Step |
Action |
Description |
---|---|---|
Step 1 |
Configure your VMware environment and NetBackup. |
See the NetBackup for VMware Administrator's Guide. Each ESX server that hosts the database must have a license for NetBackup for SQL Server license and the Enterprise Client. Install the NetBackup client software on the virtual machines that have SQL Server running. |
Step 2 |
Install the Veritas VSS provider. |
The Veritas VSS provider creates full backups, which allows VMware backups to truncate logs. You can only truncate logs if there is an existing full backup. |
Step 3 |
Configure the logon account for the NetBackup services. |
The logon account for the NetBackup Client Service and the NetBackup Legacy Network Service must meet certain requirements. See Configuring the NetBackup services for VMware backups that protect SQL Server. |
Step 4 |
(SQL Server 2012 and later) If you choose to truncate logs, ensure that the account that runs the Microsoft SQL Server Service has full permissions for the NetBackup Legacy Network Service |
This directory is |
Step 5 |
If you want to use Replication Director to manage your VMware snapshots and snapshot replicas, create a storage lifecycle policy (SLP). |
This feature requires the NetBackup Replication Director license. |
Step 6 |
Configure a VMware policy. |
See Configuring a VMware backup policy to protect SQL Server. See the NetBackup for VMware Administrator's Guide. Note that if you want to truncate logs, you must first perform a full backup without log truncation. See the following topic for more information. See About truncating logs with a VMware backup that protects SQL Server. Additional information is available on how to use Accelerator to potentially increase the speed of full VMware backups. See Using NetBackup Accelerator to increase speed of full VMware backups. |
Step 7 | If you use a other than , you need to map that identifier to the host name of the VM. | Configure this mapping 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 8 | 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. |