sql server clustering: sql server 2005 majority node set cluster -- sql server clustering

RE: sql server 2005 majority node set cluster

Chris
11/14/2005 12:27:02 PM

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

[quoted text, click to view]

Re: sql server 2005 majority node set cluster

Anthony Thomas
11/17/2005 11:14:08 PM

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

--

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server clustering group.