Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MERGE Replication - easy to restore on new server?

Posted on 2004-09-15
6
Medium Priority
?
351 Views
Last Modified: 2006-11-17
I have two servers connected over the net using merge replication.

The publisher (and distributor) machine is being replaced by a new faster box. Can I simply backup the database and restore it on the new machine and expect replication to continue as before - or would replication require a whole new snapshot etc?

The database is several gig in size so I would like to avoid starting replication from scratch if at all possible.

Thanks!..
0
Comment
Question by:niico
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 10

Expert Comment

by:AustinSeven
ID: 12066443
Just restoring the db onto the new h/w won't do it.  I think there are only two options.  

1. Rebuild the new server and configure the publication stuff as per the original server

This is obviouisly quite a lot of work.

2. Image Restore
I haven't done this myself but I think it should be possible to use a product like Acronis True Image in combination with sysprep.exe.   It wouldn't be as easy as just restoring the image to the new h/w of course - wouldn't work.   Effectively you would clone your existing server onto a different hardware platform.   I stress, however, that I haven't actually done this.   I'm interested to know myself if it works as I'm sure I'll be in the same situation as you before too long.

AustinSeven
0
 

Author Comment

by:niico
ID: 12066539
thanks AS

its looking much easier to just redo the replication to me.

if I go down that route do you think i should disable replication, then backup, then restore?

we dont have any budget for additional tools etc (and anything too complicated is quite likely to fail I would have thought).

any additional input most appreciated!
0
 
LVL 10

Expert Comment

by:AustinSeven
ID: 12073196
A brief outline plan might be...

1. Prep the new server, install SQL Server and so on
2. Script out all replication on subscribers (so you can revert if need be)
3. Turn off replication (publishers and subscribers)
4. Migrate the databases to the new server (backup/restore)
5. Create/Configure Publisher/Distribution on new server
6. Amend Subsribers
7. Turn on replicaton and test
8. Rollback if it doesn't work by: a) re-applying subscriber setup (via scripts)

A few thoughts... In advance, test out the feasibility of bringing up the new server with the same Windows server and SQL Server name (either default SQL Server name or instance name).   Of course, if you do that, you can't have both servers switched on at the same time.   In principal, this would provide some benefits:-

a) No need to change subscribers' configs.
b) Can script out the publisher/distributor from the old server and re-apply it to the new server (save a lot of time).

I suggest you block out one weekend in advance to do a 'proof of concept' test.  Based on this, finalise your plan and set aside another weekend to carry out the transition.  

Interesting?

AustinSeven
0
 

Author Comment

by:niico
ID: 12095327
thanks for all the input

well you know - i ended up doing things in a rather dirty way but its working fine.

i made sure the server name and directory structure was the same - stopped sql and copied all the databases over the top  (did a manual restore on master first). Andy replication and everything worked - and has been working fine for days.

dirty I know but seems totally fine. There were a few other database on there that are also fine, even down to users (which I guess makes sense).
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12327424
PAQed, with points refunded (100)

Computer101
E-E Admin
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question