SQL Server Performance Forum – Threads Archive
RepDoubtsDear 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) 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?
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.