Search <book_title>...

NetBackup™ for Microsoft SQL Server Administrator's Guide

Last Published: 2024-03-27

Product(s): NetBackup & Alta Data Protection (10.4)

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 configure the mappings for distributed application restores. You also need to 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 from HostA. Then add HostA to the HostB 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 example SQLHOST-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 from SQLHOST2-NB. Then add SQLHOST2-NB to the SQLHOST1-NB file.