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.

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.

Jimbo (james.goodwill (AT) googlemail (DOT) com) writes:
Given the low traffic in the newsgroups these days, it may be better
to ask in this web forum:
http://social.msdn.microsoft.com/For...cation/threads

I don't do replication, so I don't want to try to answer your question.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx