Post reply

can we configure database miroring for two databases on same server

  • August 11, 2010 at 7:25 am

    #225925

    hi all,

    can we configure the mirroring for two different databases on the same server

    1)two data bases A,B on primary server

    2)two data bases A,B on secondary server

    i already configured the mirroring in asynchronous mode. A(as principal on primary) to A(as mirror on secondary)

    can we do mirroring for the B(as principal on primary) to B(as mirror on secondary)

    Thanks & Regards,

    Anjli.

  • August 11, 2010 at 9:16 am

    #1205436

    Yes, you have to set up the Db's the same way. Restore the Db's and enable Mirroring.

    If you like you can even switch the role and balance the load of each instance.

  • August 11, 2010 at 1:14 pm

    #1205683

    You can set up mirroring on upto 10 databases on a single instance if you are running 32 bit edition. If its a 64 bit box, there is no limit on the number of databases.

  • August 11, 2010 at 3:37 pm

    #1205744

    this limit of 10 databases per server for database mirroring is a bit of an urban myth, in reality it depends on a lot of factors and is likely to be somewhat more than 10.

    for me personally I hit the limit at 25 databases on a 32 bit server, others have claimed much higher.

    there will be limitations with 64bit as well.

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

  • August 12, 2010 at 1:07 am

    #1205825

    thank you.

    what about endpoints?

    we need to create new endpoint are we can configure with same endpoint

    Regards,

    anjali.

  • August 12, 2010 at 1:17 am

    #1205828

    what about endpoints?

    we need to create new endpoint are we can configure with same endpoint

    Hello Anjali,

    You can have only one database mirroring endpoint per instance. So you should use the same endpoint for the mirroring session.

    Thanks & Regards,
    Sudeepta.
    http://twitter.com/skganguly

  • August 12, 2010 at 1:37 am

    #1205834

    k that means we can mirror the more than one database with the same endpoint right?

  • August 12, 2010 at 1:40 am

    #1205835

    Yes

    Thanks & Regards,
    Sudeepta.
    http://twitter.com/skganguly

  • August 12, 2010 at 2:06 am

    #1205842

    Thank you,

    can we change the name of the endpoint,while mirroring configuration is running.

    if so how can we change.

    regards,

    anjali.

  • August 12, 2010 at 3:22 am

    #1205873

    rishi anjali (8/12/2010)

    Thank you,

    can we change the name of the endpoint,while mirroring configuration is running.

    if so how can we change.

    regards,

    anjali.

    no, and there will never be a need to do this.

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

  • August 13, 2010 at 7:20 am

    #1206607

    That is not true. You can name the mirrorring endpoint differently. I did it without any issue.

  • August 13, 2010 at 7:36 am

    #1206626

    Pei Zhu-415513 (8/13/2010)

    That is not true. You can name the mirrorring endpoint differently. I did it without any issue.

    you changed the name of a mirroring endpoint after it was in use? How, and more importantly why?

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

  • August 13, 2010 at 8:01 am

    #1206653

    I misunderstood "change the name". I think technically you can break the mirroring, drop the endpoint, recreate the endpoint with different name, then reestablish the mirroring. I could not tell why people want to do that. I won't rename afterwards, I won't bother to change the default mirroring endpont name at first place.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply