How can I synchronize two SQL servers in seperate cities?

I have two SQL servers: One is SQL2000 on a web server (ecommerce) database, and the other located in seperate city.

Q. How can I synchronize two SQL servers in seperate cities?
Who is Participating?
Aneesh RetnakaranDatabase AdministratorCommented:
1. replication
2. log shipping
3. DTS
4. Linked Server + Trigger
kvnsdrAuthor Commented:
Care to elaborate?
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Anthony PerkinsCommented:
>>Care to elaborate?<<
Please do.  If you can give all your requirements it can help us narrow down the solutions.
kvnsdrAuthor Commented:
The goal is to have the MS SQL 2000 web server database sync changes to another SQL 2000 server over the Internet.

So far I recieve the error:

"The replication agent is not registered properly. Rerun SQL Server setup. The step failed."
kvnsdrAuthor Commented:
These are good articles and I've learned much, however I still don't understand how to actually connect to the remote (Publishing SQL) so I can PULL information back to my SQL Server.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.