SQL Server Performance Forum – Threads Archive
Relication – Remote SQL serverHi 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
http://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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.