SQL Server Performance

Relication - Remote SQL server

Discussion in 'Performance Tuning for SQL Server Replication' started by ShanuRagu, Jun 11, 2004.

  1. ShanuRagu New Member

    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
  2. satya Moderator

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page