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. Also perform 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 that acts for the master server.

To configure NetBackup server to be aware of clustered SQL Server instances

  1. 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 that belongs to the storage group that is intended for backup. If you use a virtual media server, then specify a storage unit that belongs to the virtual media server.

    • Create a backup policy schedule for VIRTSQLPOLICY.

    • Add the virtual SQL Server name (VIRTUALSERVER) to the client list.

  2. 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.

  3. Create a standard backup policy (say, STDPOLICY). Add all physical names in the cluster to the client list of STDPOLICY.

  4. Establish the permissions settings as follows for a redirected restore to a different client.

    On the master server, do one of the following:

    • Create a install_path\NetBackup\db\altnames\No file.Restrictions.

    • Create each of the files, install_path\NetBackup\db\altnames\NODEA, install_path\NetBackup\db\altnames\NODEB.

    Note:

    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.