Problem to move databases with replication configurations to new server. RRS feed

  • Question

  • Hi

    I've successfully moved our databases to new server (and also restore distribution, master and msdb to new server). now all jobs exists on new server, but publications and subscriptions not exists in Replication node!

    Does something wrong?

    how to solve this problem?

    thanks in advance


    Tuesday, May 26, 2015 10:40 AM


  • Hi Hamed,

    According to your description, you use the backup/restore method to move the database which is involved in replication, right?

    If that is the case, when restoring a backup of a replicated database to another server or database, replication settings cannot be preserved. In this case, we must recreate all publications and subscriptions after backups are restored.

    Do you have a current script of your replication settings? You can use the script to recreate your replication settings in the new server.


    Lydia Zhang

    Lydia Zhang
    TechNet Community Support

    Wednesday, May 27, 2015 2:35 AM