[Veritas-bu] Methods to Backup SQL 2005 mirror
2007-04-05 14:00:27
Subject: |
[Veritas-bu] Methods to Backup SQL 2005 mirror |
From: |
JMARTI05 at intersil.com (Martin, Jonathan (Contractor)) |
Date: |
Thu, 5 Apr 2007 14:00:27 -0400 |
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] Methods to Backup SQL 2005 mirror, Jenner, Steven
- [Veritas-bu] Methods to Backup SQL 2005 mirror, WEAVER, Simon (external)
- [Veritas-bu] Methods to Backup SQL 2005 mirror, WEAVER, Simon (external)
- [Veritas-bu] Methods to Backup SQL 2005 mirror, WEAVER, Simon (external)
- [Veritas-bu] Methods to Backup SQL 2005 mirror, WEAVER, Simon (external)
- [Veritas-bu] Methods to Backup SQL 2005 mirror, WEAVER, Simon (external)
|
|
|