Can I Mirror my Databases With a Third Party Affordably?

I need to work out a solution for my scenario.
The Problem: two GUI applications that use SQL databases as back
ends. We have a central office and three branch locations. The
central office will have three users pulling from a combination of the
applications at any given time. One branch office might have two
people using the applications, and the other offices might have one,
rarely, using the applications. The databases themselves are 600MB
and 400MB respectively. The central office has as SDSL connection of
1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
The central office has active VPN tunnels with each of the branch
offices. A server at the central office handles Exchange for the
organization, and is the primary replicator for file sharing, DNS, and
Domain Controlling (for partner servers at two of the branch
locations). I've built a new SQL server machine with SQL Server 2005
Enterprise for the central office that's more than fast and tough
enough for the needs I've described. My concern is that the DSL
connection at the central office will not be fast enough to serve the
branch offices, (especially with the VPN overhead).
My Question and Proposed Solution: I figure that the SQL server
machine that I set up can easily handle the central office. Can I
have an internet company with a fast connection mirror my databases on
their servers, (host copies of them) for the branch officesr? How
much should I pay for this per month?
As always, I greatly appreciate any help.
Thank you.
Hi
"ffrugone@.gmail.com" wrote:

> I need to work out a solution for my scenario.
> The Problem: two GUI applications that use SQL databases as back
> ends. We have a central office and three branch locations. The
> central office will have three users pulling from a combination of the
> applications at any given time. One branch office might have two
> people using the applications, and the other offices might have one,
> rarely, using the applications. The databases themselves are 600MB
> and 400MB respectively. The central office has as SDSL connection of
> 1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
> The central office has active VPN tunnels with each of the branch
> offices. A server at the central office handles Exchange for the
> organization, and is the primary replicator for file sharing, DNS, and
> Domain Controlling (for partner servers at two of the branch
> locations). I've built a new SQL server machine with SQL Server 2005
> Enterprise for the central office that's more than fast and tough
> enough for the needs I've described. My concern is that the DSL
> connection at the central office will not be fast enough to serve the
> branch offices, (especially with the VPN overhead).
> My Question and Proposed Solution: I figure that the SQL server
> machine that I set up can easily handle the central office. Can I
> have an internet company with a fast connection mirror my databases on
> their servers, (host copies of them) for the branch officesr? How
> much should I pay for this per month?
> As always, I greatly appreciate any help.
> Thank you.
>
You don't say how the application talks to the database or if the remote
locations will be doing any updates or not? Have you tested the remote
access to make sure it can communitate with the database and the application
response is ok or not?
If the remote locations are read only, you could use log shipping for a
local copy at the remote sites. If they do update the database, you may be
able to do merge replication, although a better option may be to have a web
application centrally that everyone uses.
John
|||Terminal Services/Citrix may be an option.
<ffrugone@.gmail.com> wrote in message
news:1177913253.393889.200670@.u30g2000hsc.googlegr oups.com...
> I need to work out a solution for my scenario.
> The Problem: two GUI applications that use SQL databases as back
> ends. We have a central office and three branch locations. The
> central office will have three users pulling from a combination of the
> applications at any given time. One branch office might have two
> people using the applications, and the other offices might have one,
> rarely, using the applications. The databases themselves are 600MB
> and 400MB respectively. The central office has as SDSL connection of
> 1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
> The central office has active VPN tunnels with each of the branch
> offices. A server at the central office handles Exchange for the
> organization, and is the primary replicator for file sharing, DNS, and
> Domain Controlling (for partner servers at two of the branch
> locations). I've built a new SQL server machine with SQL Server 2005
> Enterprise for the central office that's more than fast and tough
> enough for the needs I've described. My concern is that the DSL
> connection at the central office will not be fast enough to serve the
> branch offices, (especially with the VPN overhead).
> My Question and Proposed Solution: I figure that the SQL server
> machine that I set up can easily handle the central office. Can I
> have an internet company with a fast connection mirror my databases on
> their servers, (host copies of them) for the branch officesr? How
> much should I pay for this per month?
> As always, I greatly appreciate any help.
> Thank you.
>