Sure, but the question wasn't what's cheap, it was is it possible :-)
Richard Waymire, MCT, MCSE+I, MCSD, MCDBA
> Of course it's possible, but you would have to run fibre SCSI, and the
> ethernet connecton between cities, and that aint gonna be cheap...
> > The only way to do that would be with hardware support. EMC can provide
> > this, as can Compaq Storageworks.
> > --
> > Richard Waymire, MCT, MCSE+I, MCSD, MCDBA
> > > Is it possible to setup a SQL Server fail-over cluster at separate
> > > locations. Example: having two servers in different cities staying
> > sync
> > > over tcp/ip with automatic error detection and fail-over.
> > > What would be preferred way of going about this? I can't seem to find
> > > direct answer on microsoft's site.
> > > Thanks
> > > -djm
> > > *remove _nospam_ for direct reply