Configuring backups of clustered SQL Server instances (legacy SQL Server policies)
This procedure describes how to protect SQL Server clustered instances with a legacy policy that uses batch files and clients. Perform these steps after you create the virtual SQL Server (VIRTUALSERVER). The following actions must be performed on the primary server or on a NetBackup remote client console that acts for the primary server.
If you have a SQL Server cluster with multiple NICs, you must follow a different procedure.
See Configuring backups of a SQL Server cluster when you have multiple NICs (legacy SQL Server policies).
To configure backups of clustered SQL Server instances
- Open the NetBackup Administration Console.
- Create a policy (for example, VIRTSQLPOLICY).
- On the Attributes tab, configure the following:
Select the MS-SQL-Server policy type.
Specify a storage unit. If you use a virtual media server, then specify a storage unit that belongs to the virtual media server.
- On the Instances and Databases tab, select Clients for use with batch files.
- On the Schedules tab, add an automatic backup schedule.
- On the Clients tab, add the virtual SQL Server name (VIRTUALSERVER).
- On the Backup Selections tab, add one or more script names (batch files).
- Map the virtual name of the SQL Server cluster to each node in the cluster.
Configure these mappings in the Distributed Application Restore Mapping host property on the primary server.
See Configuring mappings for restores of a distributed applications, clusters, or virtual machines .
- Configure the Mapped Host Names for the SQL Server hosts in your environment.
Configure this property in Host Management on the primary server.