Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / November 2005

Tip: Looking for answers? Try searching our database.

sql server 2005 majority node set cluster

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
..::] Attilio [::.. - 14 Nov 2005 16:59 GMT
Hy all,

we want to setup a geographically distribuited cluster on which we want to
run sql server 2005...

Is it possible such a solution? If yes, where can I find an howto?

thnx

bye Attilio.
Chris - 14 Nov 2005 20:27 GMT
Each node in the cluster must be "physically" connected to the shared
storage device. The shared device can be SCSI or Fibre Channel device. SCSI I
believe is limited to 10,000 meters, Fibre of course further, however not far
enough to support servers in different states or across timezones - unless
you lay the cable...

I recommend transactional replication.

Regards,
ChrisB
MCDBA OCP
MyDatabaseAdmin.com

> Hy all,
>
[quoted text clipped - 6 lines]
>
> bye Attilio.
Anthony Thomas - 18 Nov 2005 05:14 GMT
Technically correct, but you could also employ specific technologies and
implement one of two other options: Remote Mirroring and Stretch Clustering,
especially the stretch clustering for Geographically Distributed clusters.

Check out the Remote Mirroring and Stretch Clustering in the SQL Server High
Availability series:

SQL Server 2000 High Availability Series
Implementing Remote Mirroring and Stretch Clustering
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog05.mspx

TechNet Webcast: How You Can Achieve Greater Availability with Failover
Clustering Across Multiple Sites (Level 300)
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID
=1032282061&CountryCode=US


SQL Server 2005 Mission Critical High Availability
http://www.microsoft.com/technet/prodtechnol/sql/themes/high-availability.mspx

Hope this helps.  Good luck.

Sincerely,

Anthony Thomas

> Each node in the cluster must be "physically" connected to the shared
> storage device. The shared device can be SCSI or Fibre Channel device. SCSI I
[quoted text clipped - 19 lines]
> >
> > bye Attilio.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.