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

    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.
    Jelly0228, Apr 21, 2004
    #2

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

Share This Page