Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Move database with merge replication

Answered Move database with merge replication

  • Thursday, October 04, 2012 8:05 AM
     
     
    Sign In to Vote
    0

    Hello,

    I have some databases on my sql server, which are merge replicated (for a lot of SqlCE-Pocket Devices). Now I have to move them to a new server (which is going to have the same dnsname) due to performance issues.

    I can't get access to all of the subscribing devices, because they are all around the country...

    How can I move the databases and the replications, without losing my replication? The guys with the devices shouldn't notice it ;) (maybe a short downtime)

    Thank you, Karl


    • Edited by kwuadrat Thursday, October 04, 2012 8:08 AM spelling
    •  
     

All Replies

  • Thursday, October 04, 2012 11:46 AM
     
     
    Sign In to Vote
    1

    Hello Karl,

    The Distributor is a database instance that acts as a store for replication specific data associated with one or more Publishers. Each Publisher is associated with a single database (known as a distribution database) at the Distributor.

    The distribution database stores replication status data, metadata about the publication, and, in some cases, acts as a queue for data moving from the Publisher to the Subscribers.

    Under dbo.MSmerge_subscriptions table (Distribution DataBase / System Tables) you may find all your (Devices, users).

    Query that table and verify this.

    And when you create your new instance / Server you only need is to reference that Distribution DB.

    Hope this may help you,

    Thanks

    Said RAMADA

    Gold certified from Microsoft Virtual Academy 

    Please vote as helpful or mark as answer, if it helps Cheers Said RAMADA

     
  • Thursday, October 04, 2012 1:26 PM
    Moderator
     
     Answered
    Sign In to Vote
    1
    You will need to restore the master, publication, distribution, msdb database using the keep_replication switch on the new server which must have the same host name as the old publisher.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

     
  • Thursday, October 04, 2012 2:07 PM
     
     
    Sign In to Vote
    0

    Thanks for your reply.

    Is there a problem if the old server (windows server 2003) runs sql server 2008 and the new server (windows server 2008 r2) runs sql server 2008 r2?