Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Posts
    7

    Arrow Unanswered: Backup and Restore Publications

    Hi All

    I am using SQL Server 2000 with Windows 2000 Server. There are 3 publications in my merge replication I want to take Backup of my publication and also restore the existing backup of publication.

    3 Subscribers are at remote locations what steps I should take to restore my subscription.

    Thanks for kind response

    FNK

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Backup and Restore Publications

    Do you want to keep Replication and run it in the new server where the publication was restored to?

  3. #3
    Join Date
    Sep 2003
    Posts
    7

    Re: Backup and Restore Publications

    Originally posted by joejcheng
    Do you want to keep Replication and run it in the new server where the publication was restored to?

    Yes i want to keep the replication.
    I have three publications configured on my server and I want to shift the Publisher database to new machine. I dont want to re-initialize the publications and subscriptions.
    When the database is restored to new server, I want to get all the updates from the three subscriptions, since my last backup which is currently restored.

  4. #4
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Backup and Restore Publications

    When you change over to the new server, the name of the new server has to be the same as the old. Which means you have to change the old server's name to something else first. If the use the same server name, then you can restore the publication with 'Keep_replication' clause. Restart your subscirption after that. You may have problems with the Logreader. Issue sp_repldone to refresh the LSN number in the Logreader or change the system table. If the server's name is different, you need to drop subscription, restore the publication WITHOUT 'Keep_replication' clause, and setup everything from scratch. But you don't have to reinitialize the replication if you are sure the publication and the subscription are in sync. For more information check the 'Backing Up and Restoring Replication Databases' section of BOL.

    Hope this helps. Good Luck!

  5. #5
    Join Date
    Sep 2003
    Posts
    7

    Red face

    Hi joejcheng,

    sorry I was unable to reply,

    well, till now what I have done is, I changed the machine name with my actual server name, Enabled Publication, Distribution and Subscription settings and after that Restored my Replicated Database with 'Keep_Replication' Cluse and also Restored my Distribution Database.

    I am little afraid with this statement from MSDN

    "Do not synchronize the publication database with a subscription database that has an anonymous subscription. Because anonymous subscriptions do not have enough meta data to apply changes to the publication database, such synchronization could lead to the non-convergence of data"

    Because I got Anonymous Subscription

    What should I do now? I need to change my subscription and publication options?


    FNK

  6. #6
    Join Date
    Sep 2003
    Posts
    7

    Arrow

    One more thing is that I got Pull Subscription configured on subscriber

    FNK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •