December 8, 2009 at 1:24 pm
Can anyone point me to a good SQL Server 2005 clustering resource? Maybe an amazon.com book or some Microsoft documentation? We (the DBAs) are scrambling to support new-found responsibility for SQL Server in this shop, and we are trying to get up to speed as quickly as possible. We are looking for information dealing with:
- Overview information about how database clustering works for SQL Server (active/active, active/passive, etc.)
- Care and feeding of an existing cluster
- "How to" information for common problems
- Any gotchas with reboots or software patching
- Installation information (clustering is already installed at this site, but we are looking for tips for reinstallation in the event of a severe failure)
Thanks in advance,
J
December 8, 2009 at 3:35 pm
There are a few books out there but on the other hand I like to review articles and blogs.
A few are below which I have used in the past..
http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx
http://www.sql-server-performance.com/articles/clustering/clustering_resources_p1.aspx
A good SQL book is by Rod Colledge..
http://www.manning.com/colledge/
reviewed by Brent
http://www.brentozar.com/archive/2009/03/book-review-sql-server-2008-administration-in-action/
December 8, 2009 at 10:34 pm
Here is an article with additional resources listed in the references section.
http://207.46.16.252/en-us/magazine/2007.03.sqlclusters.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 9, 2009 at 6:24 am
The white paper has a lot of what I am looking for. Thanks!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply