You guys are great. From everything I can see here, 3rd party software or
the newest version of SQL will be the answer if Clustering is deemed the
necessary evil. I am not a great fan of clustering SQL2000 without some
sort of redundancy (crazy to have to say that). I had logshipping running
fine at another place, but MS is not totally efficient with the
logshipping solution and there were many pitfalls to implementing that
solution.
You have helped immensely. Thanks!
Lisa A. Hale
Database Administrator
"Davis Ralph " <mssqldba-ezmlmshield-x93313400.[Email address protected]
01/30/2006 11:24 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: Clustering
I'll say this. Our 2 clusters(IBM 445 8ways - Compaq 8ways before that)
on SQL 2000 and W2K have been running since 2000 and NOT ONCE have they
failed over automatically. Even on the few occasions when the server
was unresponsive, and users could not login, we had to manually push
them over. Seems like a waste of hardware and $$ to me(notwithstanding
the political issues).
I prefer hot standby servers and applying logs. Clusters seem to be a
great thing for COM servers, web servers, etc., but I just don't see it
for database servers. Just my 2 cents.
Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: LHale
[mailto:mssqldba-ezmlmshield-x6734700.[Email address protected]
Sent: Monday, January 30, 2006 10: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
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
MS Sql Server LazyDBA home page