How to implement Database Mirroring with SQL2000

Hi,
Our client is located in Europe region. Our application was a web based
application using SQL Server 2000 database as the back-end, where this server
was located in Europe region. All the users will visit this site through out
the world.
Now the client was observing some performance problems in their offices in
Asia region. The reason seems to be a relatively bad connection between
Europe and Asia. The available bandwidth should be by far sufficient (10
Mbit/s), but the latency seems to be too slow (approx. 350 ms). Our Client is
checking with other providers, but they may have similar problems. The effect
is that the measured response times in their Asian office are too long
(typically 3 â' 5 seconds). Their target is to get response times below 2
seconds to make sure that the users can work efficiently.
One possible solution which has been suggested to us was that to install the
web based application also on a server in the Asian office. There would be 2
mirrored databases with the same data. The users in Asia would access this
server, whereas the users in Europe and America would access the server in
Europe. Probably it would be sufficient to update the data once a day or even
less frequently.
Does SQL Server 2000 support such a solution? Do you think this would be a
feasible solution? If this solution should be implemented, how should we
proceed?
Or else Can you suggest any other solution?
Thanks and Regards
--
oursptourspt
> Does SQL Server 2000 support such a solution? Do you think this would be a
> feasible solution? If this solution should be implemented, how should we
> proceed?
Yes it does. It could be SNAPSHOT Replication to update tthe database or
just simple BACKUP and RESTORE database
But regarding to where the server should be located it is your decision and
do some testing
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"ourspt" <ourspt@.discussions.microsoft.com> wrote in message
news:BAA5A573-735B-449F-90BD-9DB6A54D3D10@.microsoft.com...
> Hi,
> Our client is located in Europe region. Our application was a web based
> application using SQL Server 2000 database as the back-end, where this
> server
> was located in Europe region. All the users will visit this site through
> out
> the world.
> Now the client was observing some performance problems in their offices in
> Asia region. The reason seems to be a relatively bad connection between
> Europe and Asia. The available bandwidth should be by far sufficient (10
> Mbit/s), but the latency seems to be too slow (approx. 350 ms). Our Client
> is
> checking with other providers, but they may have similar problems. The
> effect
> is that the measured response times in their Asian office are too long
> (typically 3 ? 5 seconds). Their target is to get response times below 2
> seconds to make sure that the users can work efficiently.
> One possible solution which has been suggested to us was that to install
> the
> web based application also on a server in the Asian office. There would be
> 2
> mirrored databases with the same data. The users in Asia would access this
> server, whereas the users in Europe and America would access the server in
> Europe. Probably it would be sufficient to update the data once a day or
> even
> less frequently.
> Does SQL Server 2000 support such a solution? Do you think this would be a
> feasible solution? If this solution should be implemented, how should we
> proceed?
> Or else Can you suggest any other solution?
> Thanks and Regards
> --
> ourspt