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.[?] sharahttp://www.databasejournal.com/features/mssql/article.php/1438201 link to explore the task.
Also refer to the SQL server books online for more information on this setup. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>