Hi All,

I have two servers, one in the UK and one in the US. Both are running the standard edition of SQL Server 2000.

The one in the UK will be used as the main server and we wish to have the one in the US contain an identical mirror/backup of the database in the UK. This way, if there is a problem in the UK we can switch over to the US and everything will be fine.

How do we go about doing this? I guess it needs to update the backup server on a transactional basis.

Also, what happens if the UK server goes offline and we then swith to the US server (which should be in the same state as the UK one before it went offline)? The database will then be taking updates extra but it won't be able to keep the UK server informed of the changes. When the UK server comes back online it would have to be synchronised again.

This is obviously a big topic so perhaps if you could just point me in the right direction.
Thanks
Tom