Common SQL Server and Windows Clustering Questions and Problems

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Common SQL Server and Windows Clustering...

Common SQL Server and Windows Clustering Questions and Problems

Rate Topic

Display Mode

Topic Options

Author

Message

Brian Knight

Posted Sunday, October 07, 2001 12:00 AM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

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

Post #1240

Pankaj-207620

Posted Thursday, February 10, 2005 12:13 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 09, 2005 4:18 PM
Points: 1, Visits: 1

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

Post #160907

mahalingam_moorthy

Posted Friday, March 18, 2011 7:51 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 11:29 PM
Points: 8, Visits: 71

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.

Post #1080368

mahalingam_moorthy

Posted Friday, March 18, 2011 8:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 11:29 PM
Points: 8, Visits: 71

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.

Post #1080392

« Prev Topic | Next Topic »

Permissions