none
mirroring more than one RRS feed

  • Question

  • Hi,

    there are 3 servers.  can there be more than one principle and only one "partner" server?
    another word, i have the databases from different servers, servermst1 and servermst2 to mirror off to one single serverpartner?

    thanks.
    Wednesday, November 18, 2009 12:53 PM

Answers



  • Three Server Server 1, Server 2, Server 3.

    Server 1- Principal  ,Principal databases (A, B, C,....)

    Server 2- Principal , Principal Datbases (X,Y,Z,...)

    Server 3- Mirror, Mirrored Databases (A,B, C..../ X,Y,Z)...........yes, Its very much possible.

    *************************************************************************************

    Lets assume the senerios.

    Server 1 is Down

    Server 2 is running

    Server 3 is running

    The database status would be on Server 3.

    A- PRINCIPAL
    B- PRINCIPAL
    C-PRINCIPAL
    X-MIRRORED
    Y-MIRRORED
    Z-MIRRORED

    Server 1 is Down

    Server 2 is Down

    Server 3 is running

    The database status would be on Server 3.

    A- PRINCIPAL
    B- PRINCIPAL
    C-PRINCIPAL
    X-PRINCIPAL
    Y-PRINCIPAL
    Z-PRINCIPAL

    ##########################################
    points to remeber while configuring

    The Mirrored server should be capable of bear the load of 1 or 2 Servers user...Coz at the time disaster of any mishappening mirrored should behave normaly and should be able to provide the service.
    So think , plan , test and then implement is the best policy.

    Either its Sync or Asyn, it depends on the Product Edition.

    BR
    Praveen Barath

    -----------------------------
    Mark as answer if it helps

    • Marked as answer by light_wt Monday, November 30, 2009 3:15 PM
    Monday, November 23, 2009 5:34 AM
    Answerer

All replies

  • Hi ! 

    I am bit confused with your question ! Do you mean partner server as mirror server ? if that is the case than 

     If you have more than one database that needs to be mirrored, you need to mirror each database individually. Although it is possible to choose a different mirror server for each database and it is a best practice recommendation.

     Note: Mirroring can only occur on 10 or so databases per server. 
    Else if your question points as you have two database on two different servers and you want to point them both to one mirror server . Even this is possible 

    ----------------------

    Thanks,Suhas V

    • Edited by Suhas Vallala Wednesday, November 18, 2009 1:29 PM notes included
    • Proposed as answer by Suhas Vallala Monday, November 30, 2009 9:04 AM
    Wednesday, November 18, 2009 1:23 PM
  • Yea, the one server is planned on getting databases from two different principle servers.  That configuration is fine.  Right?
    Wednesday, November 18, 2009 2:02 PM
  • Yes that is fine ! two prinicipal servers pointing to one mirror server ! 

    --------------------
    Thanks,Suhas V
    Wednesday, November 18, 2009 2:14 PM
  • thanks for the insight, Suhas.

    does it matter if  both are in sync mode or async or mixed?



    Wednesday, November 18, 2009 6:53 PM
  • You can run some mirroring sessions in sync and some in asyc. The only thing you have to remember is you have to have Enterprise Edition to run in async mode.
    Ken Simmons
    http://cybersql.blogspot.com
    http://twitter.com/kensimmons
    Wednesday, November 18, 2009 7:12 PM


  • Three Server Server 1, Server 2, Server 3.

    Server 1- Principal  ,Principal databases (A, B, C,....)

    Server 2- Principal , Principal Datbases (X,Y,Z,...)

    Server 3- Mirror, Mirrored Databases (A,B, C..../ X,Y,Z)...........yes, Its very much possible.

    *************************************************************************************

    Lets assume the senerios.

    Server 1 is Down

    Server 2 is running

    Server 3 is running

    The database status would be on Server 3.

    A- PRINCIPAL
    B- PRINCIPAL
    C-PRINCIPAL
    X-MIRRORED
    Y-MIRRORED
    Z-MIRRORED

    Server 1 is Down

    Server 2 is Down

    Server 3 is running

    The database status would be on Server 3.

    A- PRINCIPAL
    B- PRINCIPAL
    C-PRINCIPAL
    X-PRINCIPAL
    Y-PRINCIPAL
    Z-PRINCIPAL

    ##########################################
    points to remeber while configuring

    The Mirrored server should be capable of bear the load of 1 or 2 Servers user...Coz at the time disaster of any mishappening mirrored should behave normaly and should be able to provide the service.
    So think , plan , test and then implement is the best policy.

    Either its Sync or Asyn, it depends on the Product Edition.

    BR
    Praveen Barath

    -----------------------------
    Mark as answer if it helps

    • Marked as answer by light_wt Monday, November 30, 2009 3:15 PM
    Monday, November 23, 2009 5:34 AM
    Answerer
  • thanks everyone.

    Praveen, you example is really helpful.  good job.
    Monday, November 30, 2009 3:16 PM