Hi Availability over WAN advice

#1

Hi Team,

Not sure of the best solution. I have two SQL servers in different parts of
the country connected via a 3mb VPN WAN. Both are used for the same front end
application but use different databases.

I want each server to be able to take over the others database in the event
of a disaster at one site. The two sites are on different domains but I plan
to merge the two into one and have a standby computer in each location with
the site specific apps.

I have two domain controllers and two TS servers at my disposal for
reconfiguration.

Any ideas on the best way to go?

Thanks
Andrew

#2

I would use bi-directional transactional replication or merge replication.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Andrew Jurgens" <AndrewJurgens (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi Team,

Not sure of the best solution. I have two SQL servers in different parts
of
the country connected via a 3mb VPN WAN. Both are used for the same front
end
application but use different databases.

I want each server to be able to take over the others database in the
event
of a disaster at one site. The two sites are on different domains but I
plan
to merge the two into one and have a standby computer in each location
with
the site specific apps.

I have two domain controllers and two TS servers at my disposal for
reconfiguration.

Any ideas on the best way to go?

Thanks
Andrew

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Hi Availability over WAN advice

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication

Hi Availability over WAN advice - 03-15-2005 , 03:09 PM

Re: Hi Availability over WAN advice - 03-16-2005 , 05:17 AM