SQL Server Performance

Move DB to other machine ,Replication can't work

Discussion in 'Performance Tuning for SQL Server Replication' started by Jelly0228, Apr 21, 2004.

  1. Jelly0228 New Member

    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.

  2. satya Moderator

    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.

Share This Page