Thursday, October 04, 2012 8:05 AM
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
Thursday, October 04, 2012 11:46 AM
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,
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 PMModeratorYou 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
- Proposed As Answer by Karthick P.K - karthick krishnamurthyMicrosoft Employee Friday, October 05, 2012 3:11 AM
- Marked As Answer by kwuadrat Wednesday, October 10, 2012 6:00 AM
Thursday, October 04, 2012 2:07 PM
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?