SQL Server Performance Forum – Threads Archive
Trans Repl without downtime on production box
I need to set up a transactional repl,where my present production box will act both as a publisher and distributer.
Now I am wondering how can I do so without downtime and missing even a single record The proc I knw giv sm downtime.Any ideas or experience in this scenerio
At last planned to do in early morning..Serched a lot but no options came out.
May try with snapshot replicationhttp://www.sql-server-performance.com/snapshot_replication_tuning.asp as defined here. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.