Common SQL Server and Windows Clustering Questions and Problems

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

  • 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

  • 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.

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply