Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Common SQL Server and Windows Clustering Questions and Problems Expand / Collapse
Author
Message
Posted Sunday, October 7, 2001 12:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
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
Posted Thursday, February 10, 2005 12:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 9, 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
Posted Friday, March 18, 2011 7:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, March 18, 2011 8:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse