Using restore instead of snapshot for merge replication

Last post 10-15-2008 7:33 PM by MohammedU. 1 replies.
Page 1 of 1 (2 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 10-15-2008 3:27 PM

    Using restore instead of snapshot for merge replication

    We have a 65GB database as a merge replication publisher. When we take a snapshot of the database and replicate it to the subscriber, it would take 12 hours to run. I read that we can backup the publisher database, restore the backup to the subscriber database, then add the subscription with "no initialization". However, we tried this and could not get it work. Has anyone done this before? Any help will be appreciated.

    lehanhsieh
  • 10-15-2008 7:33 PM In reply to

    Re: Using restore instead of snapshot for merge replication

    I have not done it in SQL 2005 but check the following BOL topic...

    SQL Server 2005 Books Online (September 2007)
    Initializing a Merge Subscription Without a Snapshot

     

    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
Page 1 of 1 (2 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.