Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Merge Replication DB backup/restore

Show all headers | View raw

Jimbo (james.goodwill@googlemail.com) writes:
> 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.
 
Given the low traffic in the newsgroups these days, it may be better
to ask in this web forum:
http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/threads

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


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.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

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