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 (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 
______________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070405/006dd7a8/attachment.htm