SQL Server Performance

RepDoubts

Discussion in 'Performance Tuning for SQL Server Replication' started by filson, Sep 20, 2006.

  1. filson New Member

    Dear Friends I am stucking on some points.Anyone can clear it for me?

    1)How free logspace of a database
    2)is there any stored procedure for creating msrepl_Tran_version column in subscriber where the tables not having that particular column
    in same way is there any sp to delete msrepl_Tran_version column from all the tables
    3)what is way to clear components previous replication specifically customstoredprocedures & triggers
    4)Peer to peer replication is better for load balancing or clustering.My all servers will sit in one office

    Thanks in Advance
    Filson
  2. satya Moderator

    1) Perform regular transaction log backups.
    2) KBAhttp://support.microsoft.com/kb/827175/ fyi.
    3) Run sp_removedbreplication [Removes all replication objects from a database without updating data at the Distributor. This stored procedure is executed at the Publisher on the publication database or at the Subscriber, on the subscription database.]
    4) What you want to achieve whether load balancing or high availability?


    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page