Re: Sql serve clustering
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Wed, 18 Jan 2006 16:38:23 -0500
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@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
- Sql serve clustering
- Prev by Date: Re: Filtering with Replication
- Next by Date: Re: restore to new hardware
- Previous by thread: Sql serve clustering
- Next by thread: Re: Sql serve clustering
- Index(es):
Relevant Pages
|
