Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 30th, 2006, 02:45 PM
Registered User
 
Join Date: Oct 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server 2005 Clustering

Can someone help me whr I can get step by step methods of doing SQL Server 2005 clustering in an Active/Passive as well as Active/Active mode.

 
Old November 2nd, 2006, 10:55 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Have you looked in Books Online at Clustering? There is some great information in there such as Failover clustering and setting up clusters. Is this what you are looking for?

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
 
Old December 14th, 2006, 04:57 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

MS is very confusing on how they do clustering. They only can do "active/passive" clustering. Using MSSQL you can only have one active node for a given database. What that means is only one box can process database transactions at a time. What Active/Passive is means that you have one box or node processing requests while the other box "passive" waits in the shadows if the primary box fails. It has an "are-you-alive" connection to the primary server. If the primary server fails to respond that it is alive. The passive server takes over shutting down the primary server. What MS calls "Active-Active" is really two active passive setups. Each node(server) is primary on one database but a different database. Then if either database server fails the other server takes over processing for both databases. It is NOT parallel processing or most peoples interpretation of "active-active" MS re-defined active-active around their architecture. If you want active active parallel processing on the same database you have to go with Oracle which allows up to 4 servers to process transactions for a single database but this is really big bucks. Postgresql also allows similar active passive functionality with Sloany and it's a free database server. MS last I checked wants 100K for thier solution.

Find the MS white papers on this subject if you want to find out what it really does. They were writen by engineers not over hyped marketing folks. If you find the white papers please post them here in this forum.


 
Old December 14th, 2006, 05:00 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you want to know how to do this you need to understand the hardware minimums. You need two servers and external storage such as a EMC type storage solution (external drive array) connected via fiber optic cable. The storage has to be external so you can have either server connect to the data if the other is down.






Similar Threads
Thread Thread Starter Forum Replies Last Post
reg conn to sql server 2005 from vb.net 2005.. veda SQL Server 2005 2 July 1st, 2008 12:16 AM
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 03:34 AM
Sql Server 2005 Gajendra SQL Server 2005 1 November 8th, 2007 04:42 AM
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM
New to SQL Server 2005 vaasmru SQL Server 2005 3 October 5th, 2006 10:26 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.