RepDoubts | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


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
1) Perform regular transaction log backups.
2) KBA 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
This posting is provided AS IS with no rights for the sake of knowledge sharing.