Search <book_title>...

Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide

Last Published: 2018-04-10

Product(s): NetBackup (8.1.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
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
4. Configuring local security privileges for SQL Server
5. About the NetBackup Discovery Service
6. Viewing the SQL Server instances and instance groups in instance management
  1. About instance actions
  2. About instance group actions
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
5. About schedule properties
6. Schedule backup types for SQL Server Intelligent Policies
7. Adding instances to a policy
8. Adding databases to a policy
9. Instance properties
10. Backup Selections tab
11. Adding filegroups or files to the backup selections list
12. Manually adding files or filegroups to the backup selections list
13. Adding instance groups to a backup policy
14. About tuning parameters for SQL Server backups
15. Backing up read-only filegroups
16. Backing up read-write filegroups
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
Performing restores of SQL Server
1. Starting the NetBackup MS SQL Client for the first time
2. Selecting the SQL Server host and instance
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
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
  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
4. Installing the Veritas VSS provider for vSphere
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
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
  1. Legacy policy backup types
  2. Converting differential backups to full backups
  3. Configuring an application backup schedule
  4. Example application backup schedule
  5. Configuring automatic backup schedules
  6. Example automatic backup schedule
8. Adding clients to a policy
9. Adding batch files to the backup selections list
10. Selecting the SQL Server host and instance
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
  1. Viewing SQL Server read-only backup sets
17. Backing up read-write filegroups
18. Backing up SQL Server database files
19. Performing partial database backups
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 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
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
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

Configuring SQL Server backups when an availability group crosses NetBackup domains

This procedure describes how to configure NetBackup to back up SQL Server availability group (AG) backups when the AG crosses NetBackup domains. You configure NetBackup to back up a single node in the AG. Then NetBackup replicates that backup to the other NetBackup domains that protect the other AG nodes.

This procedure assumes that:

One or more nodes in the AG exist in different NetBackup domains.
The following storage is available in the NetBackup source and target domains that contain the nodes of the AG:
- For OpenStorage, a disk appliance of the same type in each domain. The disk appliance type must support NetBackup Auto Image Replication (A.I.R.).
- For NetBackup deduplication, the storage that NetBackup can use for a Media Server Deduplication Pool in each domain.

See Additional resources. for complete details on storage devices, A.I.R., and how to configure these components.

To configure SQL Server backups when an availability group crosses NetBackup domains

In each domain where an AG node exists, install and configure a NetBackup master server.
In each domain, install and configure any media server(s) that you need.
Establish trust from both domains. See the Security and Encryption Guide for information on how to establish a trust relationship between master servers for Targeted A.I.R.
Choose a node of the AG (or specific replica) from which you want to take backups.
The backups in this domain act as the source backups; this domain acts as the source domain. The other NetBackup domain acts as the target domain and hosts the target storage for replication operations.
In each domain, configure a storage server.
- To open the Storage Server Configuration Wizard, choose Media and Device Management > Configure Disk Storage Servers.
- On the Welcome panel, select the type of disk storage that you want to configure.
- Use the wizard to also create a disk pool and storage unit.
On the master server in the source domain, open the NetBackup Administration Console.
- Add the target storage servers.
  To perform this configuration, open Media and Device Management > Credentials > Storage Server. Edit the storage server and add the target servers to the Replication tab.
- Add the target remote master servers to the list of trusted master servers.
  In the host properties for the master server, click the Servers node. On the Trusted Master Servers tab, add the target remote master servers.

On the master server in each of the target domains, create a storage lifecycle policy (SLP), IMPORT_AG, to import backup images from the source domain.

The Import operation should have the following properties:

Operation

Import

Destination storage

Select the storage unit that you want to use

Retention type

Target Retention

Note that the retention settings in this SLP override the retention settings in the backup policy.

On the master server of the source domain, create an SLP, EXPORT_AG, to perform a backup and to replicate the backup to the target domains.
The Backup operation should have the following properties:
Operation
Backup
Destination storage
Select the storage unit that you want to use.
Retention type
Fixed
Note that the retention settings in this SLP override the retention settings in the backup policy.
The Replication operation should have the following properties:
Operation
Replication
Send the backups to
A specific Master Server
Target master server
Select the target master server.
Target import SLP
Select the IMPORT_AG SLP that you created in step 7.
For each master server, edit the SLP parameters in the host properties if necessary.
To configure these parameters, expand Host Properties and select Master Servers. Double-click on the master server you want to edit. Click SLP Parameters.
On the master server in the source domain, create an MS-SQL-Server backup policy to back up the specific AG node.
- For the Policy storage, select the EXPORT_AG SLP that you created in step 8.
- Follow the instructions to create a policy for specific node in the AG.
  See About protecting a specific node in a SQL Server availability group .

Additional resources

NetBackup Administrator's Guide, Volume I

NetBackup Deduplication Guide

NetBackup OpenStorage Solutions Guide

http://www.netbackup.com/compatibility