X hits on this document

476 views

0 shares

0 downloads

0 comments

125 / 200

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:

a

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.

b c

Create a backup policy schedule for VIRTSQLPOLICY. Add the virtual SQL Server name (VIRTUALSERVER) to the client list.

1

2

To incorporate SQL Server backup scheduling, create an automatic schedule in the VIRTSQLPOLICY. Create the automatic schedule as follows:

a b

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, either:

  • Create a file called

install_path\NetBackup\db\altnames\No.Restrictions or

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

125

Document info
Document views476
Page views476
Page last viewedTue Dec 06 20:14:16 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments