Re: Sql serve clustering
- From: "Michael Hotek" <mike@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 20 Jan 2006 03:48:10 -0600
No. You can't not take a single database and mirror it multiple times. The
principal and mirror are a 1:1 pair. You can put as many databases in an
instance as you want to. You can mirror as many of them as you want to, but
each database can have exactly 1 mirror.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:%23nZ%23$iHHGHA.1452@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks, Is that true database mirroring in sql 2005 only allow one db in
> one server?
> It won't work for multi-dbs
>
> "mecn" <mecn2002@xxxxxxxxx> wrote in message
> news:equNgIHHGHA.208@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi,
>>
>> We are planning to have sql server failover clstering.
>> Since server failover clustering is only for hardware redundancy not the
>> databases. I still need 2 physical sql boxes(primary one is cluster
>> server) by using replication or log shipping.
>> My question is that why I need a expensice cluster server instead of
>> regualr sql server?
>>
>> Thanks,
>>
>>
>
>
.
- References:
- Sql serve clustering
- From: mecn
- Re: Sql serve clustering
- From: mecn
- Sql serve clustering
- Prev by Date: Re: Transactional replication with transform from 2000 to 2005
- Next by Date: Re: Replication bandwidth comparison
- Previous by thread: Re: Sql serve clustering
- Next by thread: Re: Replication Architecture: Design Issue and Validation
- Index(es):
Relevant Pages
|
