can we configure database miroring for two databases on same server

Question

Post reply

can we configure database miroring for two databases on same server

rishi anjali

SSC-Addicted

Points: 434
More actions
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.

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

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

Luzi62 Ten Centuries Points: 1218 More actions · Answer 1

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.

abhij33t SSC Eights! Points: 899 More actions · Answer 2

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.

george sibbald SSC Guru Points: 104210 More actions · Answer 3

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.

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

rishi anjali SSC-Addicted Points: 434 More actions · Answer 4

thank you.

what about endpoints?

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

Regards,

anjali.

Sudeepta SSCommitted Points: 1666 More actions · Answer 5

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

rishi anjali SSC-Addicted Points: 434 More actions · Answer 6

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

Sudeepta SSCommitted Points: 1666 More actions · Answer 7

Yes

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

rishi anjali SSC-Addicted Points: 434 More actions · Answer 8

Thank you,

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

if so how can we change.

regards,

anjali.

george sibbald SSC Guru Points: 104210 More actions · Answer 9

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.

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

Pei Zhu-415513 SSCarpal Tunnel Points: 4057 More actions · Answer 10

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

george sibbald SSC Guru Points: 104210 More actions · Answer 11

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?

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

Pei Zhu-415513 SSCarpal Tunnel Points: 4057 More actions · Answer 12

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.