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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    http://www.codeproject.com/KB/codegen/DatabaseHelper.aspx

    Tuesday, May 26, 2015 10:40 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Reference:
    https://msdn.microsoft.com/en-us/library/ms151152.aspx


    Thanks,
    Lydia Zhang

    Lydia Zhang
    TechNet Community Support



    Wednesday, May 27, 2015 2:35 AM