There was a very good technote for this under NBU3.4, called something like revised setup for SQL in MSCS
Regards Michael 2008/6/16, Kennedy, Cameron <[EMAIL PROTECTED]>: > > Hi all, hoping someone has some experience with backing up a Windows SQL > cluster. I am having the below issues: > Netbackup 6.5.2, AIX master + media + Windows media. > 2-node Windows SQL cluster = 2 physical servers, 2 virtual servers, 2 SQL > instances. > Typically we have 1 virtual server + instance on each physical server and > this runs fine. > Each physical server has a dedicated backup NIC on 1GB LAN, and each has a > static IP assigned. > This works for backup fine, until a failover of the cluster happens without > a failback. > > So we created virtual backup nics, that are tied to the real backup nics. We > did this via Windows cluster administrator. > Now when a cluster failover happens, the virtual backup IP's follow to the > active node - good. > However, if we set (in the hosts file) that the backup client is assigned > the virtual NIC, when the backup starts the master server can talk to the > client via the virtual backup IP, but the client responds to the master > server via the real backup IP. Netbackup promptly fails the job, because of > this discrepancy as seen in dbclient log. > > If I update the hosts file to include the real backup IP of the host, then > the job runs fine. This of course would mean that everytime the cluster > failed, I would have to update the hosts file which would be unacceptible. > > How are others doing this? > > thanks > > > > ________________________________ > > > > > This email (including any attachments) is confidential. If you are not the > intended recipient you must not copy, use, disclose, distribute or rely on > the information contained in it. If you have received this email in error, > please notify the sender immediately by reply email and delete the email > from your system. Confidentiality and legal privilege attached to this > communication are not waived or lost by reason of mistaken delivery to you. > Lend Lease does not guarantee that this email or the attachment(s) are > unaffected by computer virus, corruption or other defects. Lend Lease may > monitor incoming and outgoing emails for compliance with its Email Policy. > Please note that our servers may not be located in your country. > _______________________________________________ > Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu > > _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu