Move DB to other machine ,Replication can't work | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Move DB to other machine ,Replication can’t work

Hi,
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>