Database Mirroring - Multiple Endpoints

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 05 Mar 2008 12:24 GMT

Hi All

Is it possible to create multiple endpoints for Database Mirroring in SQL
Server 2005?

After reading that only 10 databases should be mirrored per endpoint I tried
to create another endpoint and received the following error:

An endpoint already exists with the bindings specified. Only one endpoint
supported for a specific binding. Use ALTER ENDPOINT or DROP the existing
endpoint and execute the CREATE ENDPOINT statement.

Can someone please clarify how to create an additional endpoint and/or how
to mirror more than 10 databases.

Thanks

Reply to this Message

Shailesh Khanal - 05 Mar 2008 13:59 GMT

Can you point me to the document which talks about 10 mirrored database per
endpoint.

I have more than 10 endpoints in my server.

Thank you

> Hi All
>
[quoted text clipped - 13 lines]
>
> Thanks

Reply to this Message

Saleem Hakani - 06 Mar 2008 08:59 GMT

Hi Shailesh, there's no limit on how many databases you can mirror per
server. This depends on the availability of the resorces on the server.
However, the best practice hs been to limit your server with 10.

More info on database mirroring can be found at Database Mirroring Clinic on
www.sqlcommunity.com :
http://sqlcommunity.com/Articles/SQLClinic/DatabaseMirroringClinic/tabid/117/lan
guage/en-US/Default.aspx

Signature

Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.

> Can you point me to the document which talks about 10 mirrored database per
> endpoint.
[quoted text clipped - 20 lines]
> >
> > Thanks

Reply to this Message

Saleem Hakani - 06 Mar 2008 08:55 GMT

Hi David, please take a look at the below link:
http://www.sqlcommunity.com/default.aspx?tabid=77&id=79

All mirroring connections on a server instance use a single database
mirroring endpoint.

There's no hard limit on ho many databases can be mirrored per server. This
depends on the resources available on the server. The best practice however
is to limit your SQL Server with 10 but this is not an official limit.

You may explore more about database mirroring @ Database Mirroring clinic on
www.sqlcommunity.com (Below is the link)

http://sqlcommunity.com/Articles/SQLClinic/DatabaseMirroringClinic/tabid/117/lan
guage/en-US/Default.aspx

Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.

> Hi All
>
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message