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

Re: Merge Replication DB backup/restore

From	Jimbo <james.goodwill@googlemail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Merge Replication DB backup/restore
Date	2011-09-19 07:57 -0700
Organization	http://groups.google.com
Message-ID	<6105fa41-9896-41b4-9e1e-41b5b07be7c3@z41g2000yqb.googlegroups.com> (permalink)
References	<1f293759-b2c8-4bf8-bdaf-7b73f58fb425@bi2g2000vbb.googlegroups.com>

Show all headers | View raw

Hi,

I've done some testing on this, and I think as long as I use the 'WITH
KEEP_REPLICATION' clause in my restore database commands, it should
hang together.

I've restored to a non-replicated environment, and made changes to the
database, and restored back in to the replicated arena (all restores
with KEEP_REPLICATION). Replication started and completed at the
publisher okay, and my changes were replicated to my two subscribers.

I'd still appreciate any thought other people might have on this
subject.

Thanks, James.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | 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