Relication – Remote SQL server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Relication – Remote SQL server

Hi all, Can any one please brief me all steps involved in Transactional Replication for SQL server 2000. We have maintained remote server – I just want to keep a back up data frm the remote server on to any of our local machines. All updations should happen automatically & immediately. This is why I have choosen Transactional replication. The Remote server should act as publicher as well as distributor. Any web site links & suggestions are most welcome Plz help.[?] shara link to explore the task.
Also refer to the SQL server books online for more information on this setup. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.