Using NetBackup for SQL Server with clustering solutions Configuring the NetBackup server to be aware of clustered SQL Server instances
Configuring the NetBackup server to be aware of clustered SQL Server instances
Perform the following configuration steps after the installation of a virtual SQL Server (VIRTUALSERVER) has been created and, if applicable, the installation of a virtual NetBackup media server. The following actions must be performed on the master server or on a NetBackup remote client console acting for the master server.
To configure NetBackup server to be aware of clustered SQL Server instances
Using the NetBackup Administration Console, create a MS-SQL-Server policy (for example, VIRTSQLPOLICY), to specify the storage attributes of the backup. Set up the following attributes:
Policy-storage unit: Specify a storage unit belonging to the storage group intended for backup. If you are using a virtual media server, then specify a storage unit belonging to the virtual media server.
Create a backup policy schedule for VIRTSQLPOLICY. Add the virtual SQL Server name (VIRTUALSERVER) to the client list.
To incorporate SQL Server backup scheduling, create an automatic schedule in the VIRTSQLPOLICY. Create the automatic schedule as follows:
Add an automatic backup schedule to VIRTSQLPOLICY. Add one or more script names (batch files) to the file list.
Create a standard backup policy (say, STDPOLICY). Add all physical names in the cluster to the client list of STDPOLICY.
Establish the permissions settings as follows for a redirected restore to a different client: On the master server, either:
Create a file called
Create each of the files, install_path\NetBackup\db\altnames\NODEA, install_path\NetBackup\db\altnames\NODEB.
Note: Creating the No.Restrictions file allows all clients to perform redirected restores to different clients. This parameter may need to be added and removed according to site policies.