Groups > comp.databases.ms-sqlserver > #670

Merge Replication DB backup/restore

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!nx01.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!bi2g2000vbb.googlegroups.com!not-for-mail
From	Jimbo <james.goodwill@googlemail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Merge Replication DB backup/restore
Date	Mon, 19 Sep 2011 04:18:00 -0700 (PDT)
Organization	http://groups.google.com
Lines	26
Message-ID	<1f293759-b2c8-4bf8-bdaf-7b73f58fb425@bi2g2000vbb.googlegroups.com> (permalink)
NNTP-Posting-Host	194.106.220.83
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
X-Trace	posting.google.com 1316432794 13771 127.0.0.1 (19 Sep 2011 11:46:34 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Mon, 19 Sep 2011 11:46:34 +0000 (UTC)
Complaints-To	groups-abuse@google.com
Injection-Info	bi2g2000vbb.googlegroups.com; posting-host=194.106.220.83; posting-account=JoBiqgoAAABQDMdTjVr931tFwHfqy1TT
User-Agent	G2/1.0
X-HTTP-Via	1.1 EUROPEVUK242:3128 (squid/2.7.STABLE4), 1.0 squid-11 (squid/3.1.0.13)
X-Google-Web-Client	true
X-Google-Header-Order	ARLUEHCVFNK
X-HTTP-UserAgent	Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; MS-RTC LM 8; .NET4.0C),gzip(gfe)
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:670

Show key headers only | View raw

SQL Server 2008 (10.0.4316).

Hi,

We have merge replication implemented on three servers - one publisher
and two subscribers.

I'd like to backup the publisher replicated database, and restore it
to a non-replicated server - fine, no problem. I'd then like to insert/
update/delete records from the database (on the non-replicated
server), and restore it back into the replicated arena (back to the
publisher server).

I understand the subscriber versions of the database will be 'behind'.
My intention would be to re-snapshot the subscribers, to inherit the
changes made to the restored database.

My question is... as long as I don't change the database schema, will
the database successfully restore back into three server replicated
arena, and will replication function after the restore? Or, do I have
to remove and recreate replication (Publisher and two subscribers)?

Any thoughts would be appreciated.


Regards, James.

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Merge Replication DB backup/restore Jimbo <james.goodwill@googlemail.com> - 2011-09-19 04:18 -0700
  Re: Merge Replication DB backup/restore Jimbo <james.goodwill@googlemail.com> - 2011-09-19 07:57 -0700
    Re: Merge Replication DB backup/restore Erland Sommarskog <esquel@sommarskog.se> - 2011-09-19 22:52 +0200

csiph-web