SQL Server Performance

Using passive nore to perform backups...

Discussion in 'SQL Server 2005 Clustering' started by lmundy, Apr 27, 2007.

  1. lmundy New Member

    Does anybody know if it's possible to use the passive node of an active/passive cluster to perform routine backup operations while the active node is operational.

    SQL 2005 SP1.

    Would be nice to put the passive node to work for something useful.

    Thanks.

    Lindsey
  2. bradmcgehee New Member

    The passive node does not have access to the shared array, so the answer is no.

    --------------------------------
    Brad M. McGehee, SQL Server MVP
    http://www.sqlbrad.com
  3. MohammedU New Member

    What are you trying to accomplish to perform routine backups to passive node...

    If you want you can add another drive to the active node for backups...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  4. satya Moderator

    As explained passive will be sleep mode until the fialover is initiated from Active in case of any issues.

    DO you have any issues with the backups at the moment?

    quote:Originally posted by lmundy

    Does anybody know if it's possible to use the passive node of an active/passive cluster to perform routine backup operations while the active node is operational.

    SQL 2005 SP1.

    Would be nice to put the passive node to work for something useful.

    Thanks.

    Lindsey

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. lmundy New Member

    Thanks for the replies everyone. Was looking for a way to offload the backup overhead from the production (active) server as it operates 24 x 7 using different db's based on work day around the world. Looks like the passive node just stays as insurance.

    Lindsey

    Lindsey
  6. satya Moderator

    Thats a default configuration of Active/Passive cluster and it only comes into picture when there is a problem with active node, so nothing much you can do in this case.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  7. MohammedU New Member

    You can one additional disk to the cluster and not dependent on sql server and move the disk to the second node and run the backups to it if you want to utilize the second node... but for some reason if your second node it gone then your backups will fail...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page