Lisa,

For what it's worth and I'm by no means an expert at anything other than
keeping my wife happy but currently in our ASP Hosting environment, we
have over 80 SQL servers clustered using an application called WANSync
by XOsoft. We've been using it for about a year now. We were using
another application prior called Double Take and WANSync is my opinion
is much easier to set up, administer and much more reliable.


mike

-----Original Message-----
From: LHale
[mailto:mssqldba-ezmlmshield-x6734700.[Email address protected]
Sent: Monday, January 30, 2006 8:13 AM
To: LazyDBA Discussion
Subject: RE: Clustering

Ralph,
What you are telling me is no surprise! It sounds like you don't trust
the
clustering either and that you have taken some steps to ensure that your

are fully redundant. I don't relish setting up a clustered environment
at
this juncture in the life cycle of SQL2000.
Thanks for your input.

Lisa A. Hale
Database Administrator




"Davis Ralph " <mssqldba-ezmlmshield-x17807559.[Email address
protected]
01/30/2006 11:09 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: Clustering






I'm not a big fan of clustering because it still has a single point of
failure(disk) and it never seems to fail over when you think it should.
That being said we have 2 clustered SQL servers(Politics!) and about 50
non-clustered. Even with our large web-cluster SQL box we still drop
and apply logs to a failover and BR server for safety.

I favor some form of log shipping.

Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************

-----Original Message-----
From: LHale
[mailto:mssqldba-ezmlmshield-x18338504.[Email address protected]
Sent: Monday, January 30, 2006 10:05 AM
To: LazyDBA Discussion
Subject: Clustering

I would like to pick the brains of anyone that is successfully running
SQL
in a Clustered environment. What were the hitches? Would you recommend
doing this? Is the SQL2005 Mirroring option or logshipping a better
option?
As I stated, I just want opinions at this point. Some discussion has
come
up regarding this possibility and I wanted to have some dba input. My
personal input is biased and I wanted to see how the rest of the DBA's
out
there felt.
Thanks
Lisa Hale
SQL DBA


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is
intended
solely for the person or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in reliance upon
this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and

delete
the material from any computer.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page