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

Merge Replication DB backup/restore

From	Jimbo <james.goodwill@googlemail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Merge Replication DB backup/restore
Date	2011-09-19 04:18 -0700
Organization	http://groups.google.com
Message-ID	<1f293759-b2c8-4bf8-bdaf-7b73f58fb425@bi2g2000vbb.googlegroups.com> (permalink)

Show all headers | 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