Mirroring to mulitple servers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah Day - 24 Jul 2008 22:31 GMT

Is it possible to use database mirroring in SQL 2005 to mirror from one
source server to multiple servers?

Thanks, Sarah.

Reply to this Message

Andrew J. Kelly - 25 Jul 2008 01:30 GMT

If you mean one source db to multiple mirrored servers then No it is not.
You can however mirror two different dbs from the same source server to two
different mirrored servers. You can log ship to multiple servers from a
single source db though.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> Is it possible to use database mirroring in SQL 2005 to mirror from one
> source server to multiple servers?
>
> Thanks, Sarah.

Reply to this Message

Sarah Day - 27 Jul 2008 08:08 GMT

Thanks. So could you log ship from one server and and mirror databases from
the same server to 2 seperate servers? I assume there would be a performance
hit on the source server.

> If you mean one source db to multiple mirrored servers then No it is not.
> You can however mirror two different dbs from the same source server to
[quoted text clipped - 5 lines]
>>
>> Thanks, Sarah.

Reply to this Message

Andrew J. Kelly - 27 Jul 2008 21:42 GMT

Why would you assume that? The performance may or may not be affected by
various things but mirroring one db from server A to server B and another db
from server A to server C in and of itself should not be a factor. Mirroring
is always at a db level and you can certainly mirror more than 1 db at a
time. The hardware, transaction rate and mirroring mode will determine if
there is any performance impact.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> Thanks. So could you log ship from one server and and mirror databases
> from the same server to 2 seperate servers? I assume there would be a
[quoted text clipped - 9 lines]
>>>
>>> Thanks, Sarah.

Reply to this Message