|
Home > Archive > MS SQL Server Replication > January 2006 > Sql serve clustering
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sql serve clustering
|
|
|
| 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,
| |
| Hilary Cotter 2006-01-18, 8:24 pm |
| You need clustering if downtime is very expensive to you. Clustering
provides automatic failover. If a client is connected to a cluster and the
active node in the cluster goes down, the cluster will failover
automatically to the passive node. This transfer is typically transparent to
the user. He connects as before.
Database Mirroring also does automatic failover. Log Shipping and
replication do not.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mecn" <mecn2002@yahoo.com> wrote in message
news:equNgIHHGHA.208@tk2msftngp13.phx.gbl...
> 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,
>
>
| |
|
| 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@yahoo.com> wrote in message
news:equNgIHHGHA.208@tk2msftngp13.phx.gbl...
> 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,
>
>
| |
| Michael Hotek 2006-01-20, 7:23 am |
| 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@yahoo.com> wrote in message
news:%23nZ%23$iHHGHA
.1452@TK2MSFTNGP11.phx.gbl...
> 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@yahoo.com> wrote in message
> news:equNgIHHGHA.208@tk2msftngp13.phx.gbl...
>
>
|
|
|
|
|