Steps involved in SQL Server Transactional Replication

HI

 I want to replicate db from a remote SQl Server. I want to know how to implement Transactional Replication form a remote server. Replication should happen contineously & all database operations held at Remote Server should be updated immediately at the Server at my work place.  How can I set up Remote Server for Transactional Replication (both as Publisher & Distributor) as well as Server at my work place as a subscriber.
Urgent Plz help

Shanuragu
ShanuRaguAsked:
Who is Participating?
 
edwardsearchConnect With a Mentor Commented:
http://www.microsoft.com/sql/techinfo/administration/70/default.asp

Will be useful. eventhough it is for SQL 7.0, the concept is applicable for SQL 2000

- Edward.P
0
 
rehandConnect With a Mentor Commented:
Here is a nice link

Setting Up Transactional Replication: A Step-by-step Guide
http://www.databasejournal.com/features/mssql/article.php/1438201
0
 
rehandCommented:
If that doesn't do the trick let me know
0
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.