NetBackup™ for Microsoft SQL Server Administrator's Guide
- About NetBackup for SQL Server
- Installation
- Host configuration and job settings
- Installing the Veritas VSS provider for vSphere
- Configuring RBAC for SQL Server administrators
- Managing SQL Server assets and their credentials
- About discovery of SQL Server objects
- About registering SQL Server instances and availability replicas
- Configuring backups with SQL Server Intelligent Policy
- Performance tuning and configuration options
- Protecting SQL Server availability groups
- Protecting SQL Server availability groups with intelligent policies
- Protecting SQL Server availibility groups with batch file-based policies
- About protecting the preferred replica in a SQL Server availability group (batch file-based policies)
- About protecting a specific node in a SQL Server availability group (batch file-based policies)
- About protecting the preferred replica in a SQL Server availability group (batch file-based policies)
- Protecting SQL Server with VMware backups
- About protecting an application database with VMware backups
- Create a protection plan to protect SQL Server data with a VMware backup
- Configuring backup policies with Snapshot Client
- Using copy-only snapshot backups to affect how differentials are based
- About SQL Server agent grouped snapshots
- Protecting SQL Server in a cluster environment
- Managing protection plans for SQL Server
- Restoring SQL Server with the NetBackup web UI
- Using instant access with SQL Server
- Prerequisites when you configure an instant access SQL Server database
- Configuring batch-file based policies for SQL Server backups
- Requirements to use batch files with NetBackup for SQL Server
- Schedule properties for SQL Server batch file-based policies
- Configure a batch file-based policy for a user-directed backup of read-only filegroups
- Performing backups and restores with the NetBackup MS SQL Client
- Redirect a SQL Server database to a different host (NetBackup MS SQL Client)
- Restoring multistreamed SQL Server backups
- 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
- About NetBackup for SQL Server with database mirroring
- Appendix B. Register authorized locations
Configuring permissions for redirected restores
Certain restore procedures or environments require that you configure permissions to allow a client to restore a backup that another client performed. See the NetBackup Administrator's Guide, Volume I for complete details on redirected restores.
You must configure the primary server for redirected restores if you want to redirect the restore of ClientA to ClientB.
If you use a non-root service user account, specific access must be allowed for that user when you add files to the /usr/openv/netbackup/db/altnames
directory. The service user account must have full access to these files through the ownership or group and the permissions. For example, if the service user is svcname
and its group is srvgrp
, the file can have permissions of 400
. If the file owner is for a different user and group, the file permissions must allow access to the service user. For example, 777
. Equivalent permission settings must be used in a Windows environment.
You do not need to configure redirected restores for the following configurations:
Restore databases in a SQL Server cluster to any of the nodes in the cluster
Restore databases in an availability group to any of the nodes in the availability group
Restore clustered databases in a multi-NIC environment across the private interface
Instead these environments require that you review the auto-discovered mappings for the hosts in your environment.
See Reviewing the auto-discovered mappings.
See Configuring mappings for restores of a distributed applications, clusters, or virtual machines .
To allow a specific client or host to perform a redirected restore
- On the primary server, create an
altnames
file for each client or host that you want to have permissions to perform redirected restores.For example, to give
HostB
permissions to redirect a restore, create the following file:On Windows:
install_path\NetBackup\db\altnames\HostB
On UNIX:
/usr/openv/netbackup/db/altnames/HostB
- In the
altnames
file, add the names of the hosts whose files the requesting client wants to restore.For example, assume that you want
HostB
to have permissions to redirect restores fromHostA
. Then addHostA
to theHostB
file.
To give a SQL Server host the permissions to restore backups in a multi-NIC environment
- Create an
altnames
file with the private name of the host, for exampleSQLHOST-NB
.On Windows:
install_path\NetBackup\db\altnames\SQLHOST1-NB
On UNIX:
/usr/openv/netbackup/db/altnames/SQLHOST1-NB
- In the
altnames
file, add the names of the hosts whose files the requesting client wants to restore.For example, assume that you want
SQLHOST1-NB
to have permissions to redirect restores fromSQLHOST2-NB
. Then addSQLHOST2-NB
to theSQLHOST1-NB
file.