kvnsdr
asked on
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?
Q. How can I synchronize two SQL servers in seperate cities?
ASKER
Care to elaborate?
>>Care to elaborate?<<
Please do. If you can give all your requirements it can help us narrow down the solutions.
Please do. If you can give all your requirements it can help us narrow down the solutions.
ASKER
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."
So far I recieve the error:
"The replication agent is not registered properly. Rerun SQL Server setup. The step failed."
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Help...
Help...
2. log shipping
3. DTS
4. Linked Server + Trigger