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 group 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
Configuring a VMware backup policy to protect SQL Server
Through a VMware backup policy, NetBackup can create full application-consistent backups of the SQL Server databases that reside on a virtual machine. Optionally you can use NetBackup Accelerator. VMware policies let you exclude certain virtual disks from the VMware backup. If you want to exclude specific SQL Server components, use a MS-SQL-Server policy.
To truncate logs, you must first perform a full VMware backup without log truncation. When this backup is complete, then enable log truncation in the policy.
Note that before you create a policy, you must perform additional configuration requirements:
Configure all storage options.
Configure the logon account for the NetBackup services.
See Configuring the NetBackup services for SQL Server backups and restores.
Review the auto-discovered mappings for the hosts in your environment.
More information on Accelerator is available:
See the NetBackup Administrator's Guide, Volume I.
To configure a VMware backup policy to protect SQL Server
- Create a new policy or open the policy you want to configure.
- Click the Attributes tab.
From the Policy type list, select VMware.
In the Policy storage list, select a disk storage unit.
If you want to use NetBackup Accelerator, select a PureDisk storage unit type (MSDP or PureDisk). The NetBackup device mapping files list all supported storage types.
If you want to use NetBackup Accelerator, click Use Accelerator.
Accelerator uses the initial full backup to establish a baseline. Any subsequent backups that are performed with Accelerator can run significantly faster. You may want to create an additional policy schedule that enables the Accelerator forced rescan option. This option establishes a new baseline for the next Accelerator backup.
Perform block level incremental backups is automatically selected and grayed out. On the VMware tab, the Enable block-level incremental backup option is also selected and grayed out.
- On the Schedules tab, create a schedule for full backups.
- On the Clients tab, do the following:
Click Select automatically through query.
Select NetBackup host to perform automatic virtual machine selection and the host you want to use.
Use the Query Builder to create the rules that select the virtual machines you want to back up.
- Select the VMware tab:
Select the Primary VM identifier to use to catalog the backups.
Select Enable file recovery from VM backup.
Select Enable SQL Recovery.
This option allows recovery of the databases from the virtual machine backups. If this option is disabled, you can recover the entire virtual machine from the backup, but you cannot recover the databases individually.
Do not enable Truncate logs at this time. You must first perform a full backup without log truncation, described later in this procedure.
- If you want to exclude certain disks from the VMware backup, click the Exclude Disks tab.
NetBackup excludes those disks from the VMware backup that protects SQL Server. Be sure that any disks that you exclude do not contain database data.
- Click OK to save the policy.
If you do not want to truncate transaction logs, no further action is necessary.
If you want to truncate transaction logs, continue with step 8.
- Perform a full backup without log truncation.
When the backup completes, open the policy that you created in step 1.
- Click the VMware tab and under Enable SQL Recovery, select Truncate logs.
For SQL Server, this option truncates the transaction logs when the VMware snapshot of the virtual machine is complete.
- Click OK to save the policy.
- Perform a full VMware backup.