Search <book_title>...

Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide

Last Published: 2017-10-04

Product(s): NetBackup (8.1)

Introducing NetBackup for SQL Server
1. Overview of NetBackup for SQL Server
2. Features of NetBackup for SQL Server
3. NetBackup for SQL Server terminology
4. Help for the NetBackup MS SQL Client
Installing NetBackup for SQL Server
1. Planning the installation of NetBackup for SQL Server
2. Verifying the operating system and platform compatibility for NetBackup for SQL Server
3. NetBackup server and client requirements
4. Requirements for using NetBackup for SQL Server in a NetBackup cluster
5. About the license for NetBackup for SQL Server
Instance Management for SQL Server Intelligent Policies
1. About Instance management for a SQL Server Intelligent Policy
2. About credentials used with SQL Server Intelligent Policy
3. Configuring the NetBackup services for SQL Server backups and restores (SQL Server Intelligent Policy)
4. Configuring local security privileges for SQL Server (SQL Server Intelligent Policy)
5. About the NetBackup Discovery Service (NetBackup for SQL)
6. Viewing the SQL Server instances and instance groups in instance management
  1. About instance actions (NetBackup for SQL)
  2. About instance group actions (NetBackup for SQL Server)
7. About registering SQL Server instances
8. Manually adding a SQL Server instance in instance management
Configuring SQL Server backups with SQL Server Intelligent Policy
1. About SQL Server Intelligent Policies
2. About configuring SQL Server backups with SQL Server Intelligent Policy
3. Adding a new SQL Server Intelligent Policy
4. About policy attributes for NetBackup for SQL Server
5. About schedule properties (SQL Server Intelligent Policy)
6. Schedule backup types for SQL Server Intelligent Policies
7. Adding instances to a policy (SQL Server Intelligent Policy)
8. Adding databases to a policy (SQL Server Intelligent Policy)
9. Instance properties
10. Backup Selections tab
11. Adding SQL Server filegroups or files to the backup selections list
12. Manually adding SQL Server files or filegroups to the backup selections list (SQL Server Intelligent Policy)
13. Adding instance groups to a SQL Server Intelligent Policy
14. About tuning parameters for SQL Server backups
15. Backing up read-only filegroups (SQL Server Intelligent Policies)
16. Backing up read-write filegroups (SQL Server Intelligent Policies)
Configuring NetBackup for SQL Server
1. Configuring mappings for restores of a distributed application, cluster, or virtual machine
2. Reviewing the auto-discovered mappings in Host Management
3. About NetBackup for SQL performance factors
4. Configuring the number of jobs allowed for backup operations
5. Configuring the Maximum jobs per client setting
6. Configuring multistriped backups of SQL Server
7. Performing a manual backup (NetBackup for SQL Server)
Performing restores of SQL Server
1. Starting the NetBackup MS SQL Client for the first time (legacy SQL Server policies)
2. Selecting the SQL Server host and instance (SQL Server restores)
3. Browsing for SQL Server backup images
4. Options for NetBackup for SQL Server restores
5. Restoring a SQL Server database backup
6. Staging a full SQL Server database recovery
7. Restoring SQL Server filegroup backups
8. Recovering a SQL Server database from read-write filegroup backups
9. Restoring SQL Server read-only filegroups
10. Restoring SQL Server database files
11. Restoring a SQL Server transaction log image without staging a full recovery
12. Performing a SQL Server database move
13. About performing a SQL Server page-level restore
14. Configuring permissions for redirected restores
15. Redirecting a SQL Server database to a different host
  1. About selecting a master server when redirecting a SQL database to a different location on a different host
16. Performing a restore of a remote SQL Server installation
17. About restores of a database that contain full-text catalog
18. Restoring multistreamed SQL Server backups
Protecting SQL Server data with VMware backups
1. About protecting SQL Server data with VMware backups
  1. About the Veritas VSS provider for vSphere (NetBackup for SQL Server)
  2. Limitations of using a VMware policy to protect SQL Server
2. About configuring NetBackup for VMware backups that protect SQL Server
3. Using NetBackup Accelerator to increase speed of full VMware backups (NetBackup for SQL Server)
4. Installing the Veritas VSS provider for vSphere (NetBackup for SQL)
5. Configuring the NetBackup services for VMware backups that protect SQL Server
6. Configuring a VMware backup policy to protect SQL Server
7. Configuring a VMware policy to protect SQL Server using Replication Director to manage snapshot replication
8. About truncating logs with a VMware backup that protects SQL Server
9. Restoring SQL Server databases from a VMware backup
Using NetBackup for SQL Server with Snapshot Client
1. About NetBackup Snapshot Client for SQL Server
2. How SQL Server operations use Snapshot Client
3. Configuration requirements for SQL Server snapshot and Instant Recovery backups
4. Configuring a snapshot policy for SQL Server
5. Configuring a policy for Instant Recovery backups of SQL Server
6. Using copy-only snapshot backups to affect how differentials are based
7. About SQL Server agent grouped backups (legacy SQL Server policies)
Protecting SQL Server in high availability (HA) environments
1. About SQL Server high availability (HA) environments
2. About using NetBackup to protect SQL Server availability groups
3. Configuring backups of clustered SQL Server instances (SQL Server Intelligent Policy)
4. Configuring backups of clustered SQL Server instances (legacy SQL Server policies)
5. Performing a restore of a virtual SQL Server instance
6. About NetBackup for SQL Server with database mirroring
7. Configuring NetBackup to support database log-shipping
8. Backing up SQL Server in an environment with log shipping
Backup and recovery concepts
1. Overview of SQL Server backup and recovery concepts
2. What are the components of NetBackup for SQL Server?
3. How does NetBackup resolve SQL Server host and instance names?
4. How does NetBackup for SQL Server back up a database?
5. How does NetBackup for SQL Server recover a database?
6. Protecting SQL Server files and filegroups
7. About recovery considerations for SQL Server files and filegroups
8. Reducing backup size and time by using read-only filegroups
9. What factors affect the data transfer rate during a SQL Server backup or restore operation?
10. About recovery factors for SQL Server
Using NetBackup for SQL Server with multiple NICs
1. About configuration of SQL Server backups with multiple NICs
2. Configuring the NetBackup client with the private interface name
3. Configuring backups of SQL Server when you have multiple NICs (SQL Server Intelligent Policies)
4. Configuring backups for SQL Server when you have multiple NICs (legacy SQL Server policies)
5. Performing restores of SQL Server when you have multiple NICs
6. Configuring backups of a SQL Server cluster when you have multiple NICs (SQL Server Intelligent Policies)
7. Configuring backups of a SQL Server cluster when you have multiple NICs (legacy SQL Server policies)
8. Creating a batch file for backups of a SQL Server cluster when you have multiple NICs (legacy SQL Server policies)
9. Performing restores of a SQL Server cluster when you have multiple NICs
Configuring backups with legacy SQL Server policies using clients and batch files
1. About legacy SQL Server policies
2. About configuring backups with legacy SQL Server policies
3. Configuring the NetBackup services for SQL Server backups and restores (legacy SQL Server policies)
4. About SQL Server security with NetBackup legacy backup policies
5. About using batch files with NetBackup for SQL Server
  1. Keywords and values used in batch files
  2. Creating a batch file
  3. Running batch files
6. Adding a new SQL Server legacy policy
7. About schedule properties (legacy SQL Server policies)
  1. SQL Server backup types (for legacy policies)
  2. Converting differential backups to full backups
  3. Configuring an application backup schedule (NetBackup for SQL Server)
  4. Example application backup schedule (NetBackup for SQL Server)
  5. Configuring automatic backup schedules (NetBackup for SQL Server)
  6. Example automatic backup schedule (NetBackup for SQL Server)
8. Adding clients to a policy
9. Adding batch files to the backup selections list (NetBackup for SQL Server legacy policy)
10. Selecting the SQL Server host and instance (SQL Server backups with legacy backup policies)
11. Options for SQL Server backup operations
12. About viewing the properties of the objects selected for backup
13. Performing user-directed backups of SQL Server databases
14. Backing up SQL Server transaction logs
15. Backing up SQL Server database filegroups
16. Backing up read-only filegroups (legacy SQL Server backup policies)
  1. Viewing SQL Server read-only backup sets
17. Backing up read-write filegroups (legacy SQL Server backup policies)
18. Backing up SQL Server database files
19. Performing partial database backups (SQL Server legacy backup policies)
20. Performing a backup of a remote SQL Server installation
21. About file checkpointing with NetBackup for SQL Server
22. About automatic retry of unsuccessful SQL Server backups
Performing user-directed operations with dbbackex
1. Using dbbackex to perform user-directed operations for SQL Server
2. Using client-based schedulers with dbbackex
Using bplist to retrieve a list of SQL Server backups
1. About using bplist to retrieve SQL Server backups
2. About NetBackup for SQL Server backup names
SQL Server backups and restores in an SAP environment (legacy SQL Server policies)
1. About SQL Server backups and restores in an SAP environment
2. About manual backups of SQL Server in an SAP environmentAbout manual backups of SQL Server in an SAP environment
3. About policy configuration for SQL Server in an SAP environment
Troubleshooting
1. About monitoring NetBackup for SQL Server operations
2. About NetBackup reports for SQL Server troubleshooting
3. About debug logging for SQL Server troubleshooting
4. Setting the maximum trace level for NetBackup for SQL Server
5. Troubleshooting credential validation with instance management (NetBackup for SQL Server)
6. About minimizing timeout failures on large SQL Server database restores
7. Troubleshooting VMware backups and restores of SQL Server
8. Delays in completion of backup jobs
9. SQL Server log truncation failure during VMware backups of SQL Server
10. SQL Server restore fails when you restore a SQL Server compressed backup image as a single stripe or with multiple stripes
11. Incorrect backup images are displayed for availability group clusters
12. A restore of a SQL Server database fails with Status Code 5, or Error (-1), when the host name of the SQL Server or the SQL Server database name has trailing spaces
13. A move operation fails with Status Code 5, or Error (-1), when the SQL Server host name, the database name, or the database logical name has trailing spaces
Disaster recovery of a SQL Server
1. About disaster recovery of SQL Server
2. Preparing for disaster recovery of SQL Server
3. Recovering SQL Server databases after disaster recovery
NetBackup for SQL dialog box topics
1. Backup History Options dialog box
2. Backup Microsoft SQL Server Objects dialog box
3. Manage Scripts
4. NetBackup client properties
5. Restore Microsoft SQL Server Objects dialog box
6. Browse Backup Selections dialog box
7. Browse Backup Selections dialog box
NetBackup for SQL dialog box fields
1. Backup History Options field descriptions
2. Manage Scripts field descriptions
3. NetBackup client properties field descriptions
4. Viewing properties of objects selected for restore
5. About selecting database objects for restore
6. SQL Server connection properties
7. SQL Server connection properties field descriptions
Appendix A. Sample batch files
1. About sample backup batch files for legacy SQL Server policies
2. About sample restore batch files
Appendix B. Multiplexed backups
1. Configuring multiplexed backups of SQL Server
2. Restoring a multiplexed SQL Server backup
Appendix C. Register authorized locations
1. Registering authorized locations used by a NetBackup database script-based policy

Reviewing the auto-discovered mappings in Host Management

In certain scenarios, a NetBackup host shares a particular name with other hosts or has a name that is associated with a cluster. To successfully perform backups and restores with NetBackup for SQL Server, you must approve each valid Auto-Discovered Mapping that NetBackup discovers in your environment. These mappings appear in the Host Management properties on the master server. You can also use the nbhostmgmt command to manage the mappings. See the Security and Encryption Guide for more details on Host Management properties.

Examples of the configurations that have multiple host names include:

A host is associated with its fully qualified domain name (FQDN) and its short name or its IP address.
If the SQL Server is clustered, the host is associated with its node name and the virtual name of the cluster.

Auto-discovered mappings for a cluster

In a SQL Server cluster environment, you must map the node names to the virtual name of the cluster if the following apply:

If the backup policy includes the cluster name (or virtual name)
If the NetBackup client is installed on more than one node in the cluster
If the NetBackup Client is only installed on one node, then no mapping is necessary.

To approve the auto-discovered mappings for a cluster

In the NetBackup Administration Console, expand Security Management > Host Management.

At the bottom of the Hosts pane, click the Mappings for Approval tab.

The list displays the hosts in your environment and the mappings or additional host names that NetBackup discovered for those hosts. A host has one entry for each mapping or name that is associated with it.

For example, for a cluster with hosts client01.lab04.com and client02.lab04.com, you may see the following entries:

Host	Auto-discovered Mapping
client01.lab04.com	client01
client01.lab04.com	clustername
client01.lab04.com	clustername.lab04.com
client02.lab04.com	client02
client02.lab04.com	clustername
client02.lab04.com	clustername.lab04.com

If a mapping is valid, right-click on a host entry and click Approve.
For example, if the following mappings are valid for client01.lab04.com, then you approve them.
Auto-discovered Mapping
Valid name for
client01
The short name of the client
clustername
The virtual name of the cluster
clustername.lab04.com
The FQDN of the virtual name of the cluster
When you finish approving the valid mappings for the hosts, click on the Hosts tab at the bottom of the Hosts pane.
For hosts client01.lab04.com and client02.lab04.com, you see Mapped Host Names/IP Addresses that are similar to the following:
Host
Mapped Host Names/IP Addresses
client01.lab04.com
client01.lab04.com, client01, clustername, clustername.lab04.com
client02.lab04.com
client02.lab04.com, client02, clustername, clustername.lab04.com
If you need to add a mapping that NetBackup did not automatically discover, you can add it manually.
Click on the Hosts tab, then right-click in the Hosts pane and click Add Shared or Cluster Mappings. For example, provide the name of the virtual name of the cluster. Then click Select Hosts to choose the node names in the cluster to which you want to map that virtual name.

Auto-discovered Mapping	Valid name for
client01	The short name of the client
clustername	The virtual name of the cluster
clustername.lab04.com	The FQDN of the virtual name of the cluster

Host	Mapped Host Names/IP Addresses
client01.lab04.com	client01.lab04.com, client01, clustername, clustername.lab04.com
client02.lab04.com	client02.lab04.com, client02, clustername, clustername.lab04.com

In Table: Example mapped host names for SQL Server environments, FCI is a SQL Server failover cluster instance. AG is an availability group. WSFC is Windows Server Failover Cluster.

Table: Example mapped host names for SQL Server environments

Environment	Host	Mapped Host Names
FCI (cluster with two nodes)	Physical name of Node 1	Virtual name of the SQL Server cluster
	Physical name of Node 2	Virtual name of the SQL Server cluster

AG (primary and secondary)	Primary name	WSFC name
	Secondary name	WSFC name

AG with an FCI (primary FCI and secondary FCI)	Primary FCI name	WSFC name
	Secondary FCI name	WSFC name
	Physical name of Node 1	Virtual name of the SQL Server cluster
	Physical name of Node 2	Virtual name of the SQL Server cluster

Auto-discovered mappings for a SQL Server cluster in a multiple NIC environment

If you have a SQL Server cluster in a multi-NIC environment, you need to approve each valid Auto-Discovered Mapping for the hosts in that environment. You must map the virtual name of the SQL Server cluster on the private network to the private name of each SQL Server cluster node.

To approve the auto-discovered mappings for a SQL Server cluster in a multiple NIC environment

In the NetBackup Administration Console, expand Security Management > Host Management.
At the bottom of the Hosts pane, click the Mappings for Approval tab.
The list displays the hosts in your environment and the mappings or additional host names that NetBackup discovered for those hosts. A host has one entry for each mapping or name that is associated with it.
For example, for a cluster in a multi-NIC environment with hosts client01-bk.lab04.com and client02-bk.lab04.com, you may see the following entries:
Host
Auto-discovered Mapping
client01-bk.lab04.com
clustername-bk.lab04.com
client02-bk.lab04.com
clustername-bk.lab04.com
If a mapping is valid, right-click on a host entry and click Approve.
For example, if following mapping is valid for client01-bk.lab04.com, then you approve it.
Auto-discovered Mapping
Valid name for
clustername-bk.lab04.com
The virtual name of the SQL Server cluster on the private network
When you finish approving the valid mappings for the hosts, click on the Hosts tab at the bottom of the Hosts pane.
For hosts client01-bk.lab04.com and client02-bk.lab04.com, you may see the following Mapped Host Names/IP Addresses.
Host
Mapped Host Names/IP Addresses
client01-bk.lab04.com
clustername-bk.lab04.com
client02-bk.lab04.com
clustername-bk.lab04.com
If you need to add a mapping that NetBackup did not automatically discover, you can add it manually.
Click on the Hosts tab, then right-click in the Hosts pane and click Add Shared or Cluster Mappings. For example, provide the name of the virtual name of the cluster. Then click Select Hosts to choose the hosts to which you want to map that virtual name.

Host	Auto-discovered Mapping
client01-bk.lab04.com	clustername-bk.lab04.com
client02-bk.lab04.com	clustername-bk.lab04.com

Auto-discovered Mapping	Valid name for
clustername-bk.lab04.com	The virtual name of the SQL Server cluster on the private network

Host	Mapped Host Names/IP Addresses
client01-bk.lab04.com	clustername-bk.lab04.com
client02-bk.lab04.com	clustername-bk.lab04.com

Example mapped host names for a SQL Server cluster in a multi-NIC environment

Table: Example mapped host names for a SQL Server cluster in a multi-NIC environment

Host	Mapped Host Names
Private name of Node 1	Virtual name of the SQL Server cluster on the private network
Private name of Node 2	Virtual name of the SQL Server cluster on the private network