SQL Server Performance Forum – Threads Archive
Move DB to other machine ,Replication can’t workHi,
I moved all of the databases(include system db and user db) from A server to B server: backup the databases form A,and then restored them to B.Now sql server service is working, and the replication database which named "Product" was marked "share" yet.But I can not see any publication.Why?
The distributor in B server is still A.how to change it ? Thanks for any help. Jelly.
Delete the replication and re-enable the replication to take new settings.
Refer to SQL Server error log for any information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.