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.
MS Sql Server LazyDBA home page