Symantec Netbackup SQL Database in Cluster backup issue
Let me explain the infrastructure which we have
- Windows 2008 R2 x64 two node cluster
- SQL 2008 cluster (We have SQL cluster with two different cluster instance running on each host)
- Netbackup 5220 Appliance
- Netbackup 22.214.171.124
We are having issue backing up one of the SQL server, where as we are able to backup the one SQL cluster instance which is running one of the cluster node.
The SQL cluster vitual hostnames
On node1 - we are running the cluster virtual1.domain.com
On node 2 - we are running the cluster virtual2.domain.com
But when we connect to the SQL cluster via SQL Management Studio for node1 we use the server name - virtual1
whereas for the second node we use the server name as - virtual2\instance
When we connect to create the NBU SQL script, the NBu SQL client will connect to virtual2\instance name and also when we create a .bch script the hostname within the script file is listed as virtual2\instance name.
While we create the NBU SQL policy we have mentioned the virtual2 name in the client list and the script, but the backup fail with, client couldnt able to connect.
Appreciate if any of you have come across same setup and resolved the problem of SQL backup using Netbackup 7.5.x.x