Synchronizing two MS SQL 2000 database server

[khenaidoo]

Hi All,

I will have to setup two windows 2000 servers at separate locations. Each server will host the MS SQL 2000 database. The data on both database will need to be in sync in real time. Is it possible to do? If yes, any suggestions of how do do it?

Thanks
Khen

[MAK]

"real time" "real time" - not possible.

Latency will always be there. (Network speed and traffic)

SQL Server Features...
1. Transactional Replication
2. Log Shipping


many third party tools are available too.

[khenaidoo]

Any documentation or good links?

Thanks
Khen

[rmiao]

Check sql books online and microsoft knowledge base.

[MAK]

Books Online has all the details

Replication:
http://www.mssqlserver.com/replication/primer_p1.asp

http://www.informit.com/articles/article.asp?p=169612

Log Shipping
http://www.databasejournal.com/featu...le.php/1467581
http://support.microsoft.com/default...b;en-us;325220
http://www.winnetmag.com/Articles/Ar...30/pg/1/1.html

[skhanal]

To keep two databases in synch you have to code your application to use distributed transaction. It makes sure that a transaction is not committed unless it is committed in both servers.

A major drawback with this is, if your network link is down, you can't do anything.