Veritas-bu

Re: [Veritas-bu] Windows 2-node cluster backup

2008-06-16 10:11:55
Subject: Re: [Veritas-bu] Windows 2-node cluster backup
From: "WEAVER, Simon \(external\)" <simon.weaver AT astrium.eads DOT net>
To: "Kennedy, Cameron" <Cameron.Kennedy AT bovislendlease DOT com>, <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Mon, 16 Jun 2008 14:33:28 +0100
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: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Kennedy, Cameron
Sent: Monday, June 16, 2008 1:59 PM
To: veritas-bu AT mailman.eng.auburn DOT 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 AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<Prev in Thread] Current Thread [Next in Thread>