Hi Cameron
Well, in simple terms, 2 Node win2k3 cluster, 1 Virtual SQL Server, No
NetBackup software configured in a cluster.
The application (SQL) is configured to perform the backup using its
virtual server name. Obviously during a backup, if it fails, Netbackup
will abort, but its not a big deal as it re-runs many times during the
day.
Not had the SQL clusters configured with multiple virtual names im
afraid. Its been a case of one SQL Instance per 2-node cluster (due to
project/secure reasons).
Simon
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kennedy,
Cameron
Sent: Monday, June 16, 2008 1:59 PM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] Windows 2-node cluster backup
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.
This email (including any attachments) may contain confidential and/or
privileged information or information otherwise protected from disclosure.
If you are not the intended recipient, please notify the sender
immediately, do not copy this message or any attachments and do not use it
for any purpose or disclose its content to any person, but delete this
message and any attachments from your system. Astrium disclaims any and all
liability if this email transmission was virus corrupted, altered or
falsified.
---------------------------------------------------------------------
Astrium Limited, Registered in England and Wales No. 2449259
REGISTERED OFFICE:-
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
