Common SQL Server and Windows Clustering Questions and Problems

• Brian Knight

  One Orange Chip

  Points: 27249

  More actions

  October 7, 2001 at 12:00 am

  #157999

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/commonclusterproblems_1.asp

  Brian Knight
  Free SQL Server Training Webinars

• Pankaj-207620

  Grasshopper

  Points: 19

  More actions

  February 10, 2005 at 12:13 pm

  #541643

  I got disspointed after looking at the title and then reading the article. I was expecting the answers for the below question.

  1. Say for 2 nodes cluster, Do we need to have 2 copies of Databases( 1 on each node)

  2. Hows does the data Synchronization between different nodes of databases takes place?

  3. In Active/Passive mode, does the passive node database is exactly in the same state (in terms of data) as that of Active?

  Pankaj A. Chitriv

  ---

  Kindest Regards,

  Pankaj

  Tech Lead

• mahalingam_moorthy

  SSC Enthusiast

  Points: 146

  More actions

  March 18, 2011 at 7:51 am

  #1300502

  Hi Friends,

  Sql server 2008 two node clustering we remove the cluster using sql server 2008 management studion itself no need to go for control panal.

  Thanks,

  M.Mahalingamoorthy

  DBA

  EY GSS India.

• mahalingam_moorthy

  SSC Enthusiast

  Points: 146

  More actions

  March 18, 2011 at 8:15 am

  #1300524

  Q1: Say for 2 nodes cluster, Do we need to have 2 copies of Databases( 1 on each node).

  Ans: Because in a clustering environment normally sql database hosted only SAN(single point of database copy only).

  Q2:Hows does the data Synchronization between different nodes of databases takes place?

  Ans: Sql server 2000/2005/2008-environment, sql server having own quorum mechanism, we need to select the quorum model and MSdtc .

  Q3:In Active/Passive mode, does the passive node database is exactly in the same state (in terms of data) as that of Active?

  Ans: yes--Because if something happened the active node all the sql resource has moved to passive node with in 15 secs. so that data has same state.

  Thanks,

  M.Mahalingam

  SQL DBA.