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.