multiple sql servers?

We are having some slow connections to our sql server. The server is locate
d
at Site A, everyone at Site A can connect to the server through the LAN
quickly, just the way things should be. People at Site B, however, connect
to the SQL Server at Site A over a WAN; this causes the connection to be
slow. We were wondering if it is possible to install a second SQL Server at
Site B that will replicate with the server at Site A maybe once every night.
This way people at Site B could connect to a server that is on their LAN.Hi,
Before doing that could you people verify with your network folks about the
network speed. It can be because of the slow network and can be solved.
Once you find that network can not be made fast, then probably you could
plan to setup a new database at Site B.
After that use some scripting mechanism / DTS / Logshipping to sync the
database with Site A.
Thanks
Hari
SQL Server MVP
"Benjamin" <Benjamin@.discussions.microsoft.com> wrote in message
news:717DC17B-C748-4718-AC0F-7420F280DDEE@.microsoft.com...
> We are having some slow connections to our sql server. The server is
> located
> at Site A, everyone at Site A can connect to the server through the LAN
> quickly, just the way things should be. People at Site B, however,
> connect
> to the SQL Server at Site A over a WAN; this causes the connection to be
> slow. We were wondering if it is possible to install a second SQL Server
> at
> Site B that will replicate with the server at Site A maybe once every
> night.
> This way people at Site B could connect to a server that is on their LAN.