has anyone here done Stretch Clustering?

http://www.microsoft.com/technet/pro...sql/2000/deplo
y/hasog05.mspx
Has anyone used the Stretch Clustering techniques used in
this article? If it works that good theres no reason to
use Transactional Replication is there? What are the
goods/ bads?
TIA, ChrisR
One of the banks here uses this quite successfully...
There is a difference between this and transactional replication...
Stretch clustering allows ONLY the primary node to access the data at any
given time.
There is a limit of 4 nodes on the cluster.
The hardware is more expensive.
This is a high availability solution
Replication may have many subscribers to the same publication, all
accessed/updated concurrently.
Less expensive hardware is required.
This works on SQL Standard Edition (Clustering requires EE)
Replication does NOT replicate system tables ( no users/permissions, etc) ,
but the Stretch clustering covers everything.
Replication is intended to make near real time copies of the data available
locally and is not a high availability solution...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2ae5201c4685a$22b5c660$a601280a@.phx.gbl...
> http://www.microsoft.com/technet/pro...sql/2000/deplo
> y/hasog05.mspx
> Has anyone used the Stretch Clustering techniques used in
> this article? If it works that good theres no reason to
> use Transactional Replication is there? What are the
> goods/ bads?
> TIA, ChrisR