Enterprise Vault/SQL cluster, status 39, and virtual sql server name....
Enterprise Vault 9.0. Netbackup 7.5. Microsoft SQL 2005 cluster w/ 3 physical nodes running on Server 2008 R2, with 3 SQL instances running on them (i.e. 3 virtual SQL server names).
The Netbackup, SQL, and Vault environments have been in production a long time w/ no issues. But I just now reconfigured the Netbackup policies for Enterprise Vault in order to take advantage of the built in agent and some of it's features.
Problem is I get a Status 39. Per this http://www.symantec.com/business/support/index?page=content&id=TECH129016, if I change the "Client Name" on the active node of the SQL server, all is well.
But, we have 3 SQL instances (i.e. 3 virtual SQL server names), so there are two problems with that:
- If I don't change the name on all three of the nodes, then the Enterprise Vault backups will again fail with a status 39 if the required SQL instance is running on any other node.
-
If I change the name on all 3 nodes, the Enterprise Vault backups should always work. But since I have 2 other SQL instances (virtual SQL servers) in the cluster, I see failures for the other SQL backups on the other 2 SQL instances?
So, is there any other solution or work around? Otherwise it seems like I just need to pick the lesser of the two evils above, so to speak.