SQL Backup on two-node cluster with multiple instances
Created: 14 Mar 2013 | 3 comments
So, I got thrown into the Netbackup area (which isn't a bad thing. I like the challenge, but...) and have been trying to clean up our policies, etc. I'm having issues with out SQL cluster right now.
Our set up is basically:
We currently have 4 separte jobs set (one for each instance). This is a lot of administrative overhead. I'd like to be able to just create one job based on the Virtual Cluster Name and have it figure out what node it's on and grab it. Everything I've tried so far has failed. My latest thought is something along these lines, but I'm sure I'm way off base.
Any help would greatly appreciated.