Hi Guys,
Apologies for the late response but I have been on holiday over Easter.
Simon; Jonathon is correct in his assumption and apologies if my earlier
mail was unclear.
SQL 2005 clustering and mirroring are two distinct concepts. Mirroring
doesn't utilize a virtual server and shared storage; instead a database
is stored on one server and copied to another, providing a standby copy
of the database that can service clients in the event of a server
failure.
As far as I can see the 'hot' backup element should be the same as
backing up a stand alone client the only question is whether it is
advisable to backup up both servers (the primary and mirror) or just to
backup the primary and perform a restore with move operation in the
event of failure.
I'm guessing I will just load the SQL agent on both servers and perform
daily full backups on both just for ease.
Thanks for your assistance on this matter.
Regards,
Steve.
-----Original Message-----
From: WEAVER, Simon (external) [mailto:simon.weaver at astrium.eads.net]
Sent: 10 April 2007 07:59
To: 'Martin, Jonathan (Contractor)'; Jenner, Steven;
veritas-bu at mailman.eng.auburn.edu
Subject: RE: [Veritas-bu] Methods to Backup SQL 2005 mirror
Hello Jonathan
That's not how I read it from the originators post.
If its in a cluster scenario, and there are 2 nodes, then as long as
there
is a configured virtual server name that NetBackup can connect to and
perform the backups, it will not care what node it is hosted on.
But is it Mirror Steven?
Regards
Simon Weaver
3rd Line Technical Support
Windows Domain Administrator
EADS Astrium Limited, B23AA IM (DCS)
Anchorage Road, Portsmouth, PO3 5PU
Email: Simon.Weaver at Astrium-eads.net
-----Original Message-----
From: Martin, Jonathan (Contractor) [mailto:JMARTI05 at intersil.com]
Sent: 05 April 2007 19:00
To: Jenner, Steven; WEAVER, Simon (external);
veritas-bu at mailman.eng.auburn.edu
Subject: RE: [Veritas-bu] Methods to Backup SQL 2005 mirror
Good shot Simon, but I think this is a data mirror (as opposed to
cluster?)
In that case, they have a SQL server configured to instantly replicate
any
changes of a database to another SQL server that is not attached to the
same
physical storage. The mirror is more than likely read only. The last
time
I had a configuration similar to this we backed up both. I don't think
you
need to through. Its a fairly strait forward process should the live
data
server go down, to move that database back or make the read only copy
live.
I haven't played with SQL 2005 but I managed several databases like this
with SQL 2000. Generally speaking we used data mirrors to take
processes
with high loads (huge queries, backups etc) off the production server.
-Jonathan
________________________________
From: veritas-bu-bounces at mailman.eng.auburn.edu on behalf of Jenner,
Steven
Sent: Thu 4/5/2007 11:34 AM
To: WEAVER, Simon (external); veritas-bu at mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] Methods to Backup SQL 2005 mirror
Hi Simon,
Yeh I'm also backing up a SQL2005 cluster but am unsure how to proceed
with
regard to a mirror installation. Obviously in a mirror setup there is
only
one 'live' db but depending on whether it has failed over it could be
node A
or node B. Therefore should I back up both nodes and therefore purchase
two
agent licenses or do I only backup the one 'live' DB and switch the
backup
over if the solution fails over?
Cheers,
Steve.
________________________________
From: WEAVER, Simon (external) [mailto:simon.weaver at astrium.eads.net]
Sent: 05 April 2007 14:46
To: Jenner, Steven; veritas-bu at mailman.eng.auburn.edu
Subject: RE: [Veritas-bu] Methods to Backup SQL 2005 mirror
Steve
Well I backup sql2005 as a cluster.
Agent is installed on 2 nodes, backup configured as a Virtual Name.
I basically followed the sql agent documentation and through trial and
error
got it working, using Windows authentication (once the account was
configured within sql to allow backups to be done!).
Regards
Simon Weaver
3rd Line Technical Support
Windows Domain Administrator
EADS Astrium Limited, B23AA IM (DCS)
Anchorage Road, Portsmouth, PO3 5PU
Email: Simon.Weaver at Astrium-eads.net
<mailto:Simon.Weaver at Astrium-eads.net>
-----Original Message-----
From: Jenner, Steven [mailto:Steven.Jenner at uk.telstra.com]
Sent: 05 April 2007 12:00
To: veritas-bu at mailman.eng.auburn.edu
Subject: [Veritas-bu] Methods to Backup SQL 2005 mirror
Hi,
Is anyone out there using the NetBackup SQL agent to back up a
SQL
2005 mirror (with witness server)?
I have been asked to test this and am unsure of the best way to
proceed i.e. do I need to install the agent on both servers (principal
and
mirror) and back both up nightly or do I just back up the principal?
There appears to be little info in the documentation and my SQL
knowledge is limited so I'm unsure of the best way to proceed.
Thanks in advance,
Steve.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security
System.
For more information please visit
http://www.messagelabs.com/email
______________________________________________________________________
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For
more information please visit http://www.messagelabs.com/email
______________________________________________________________________
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
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
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
|
