Any available solution do creat 3 databases correspondence?

Hi,

we have three dabases:

1. Two localDatabases in two offices, Main Office & Branch Office, each office in a diffrent city!!

2. One remoteDatabes exist in on the internet server.

all of it are with the same exact architecture, we are planning to upload and download to & from remoteDatabase to get the same data in all of them.

any available solution to do this with SQL Server 2005 ?

You may wish to investigate the use of Replication (see Books Online).

A couple of other options include: database mirroring and log shipping.

My guess (based on scant information) is that one of the Replication schemes is most likely what you seek.

|||Thanks Arnie,,