Showing posts with label realized. Show all posts
Showing posts with label realized. Show all posts

Wednesday, March 21, 2012

Restoring publisher and subscriber databases on other computers

Is is possible to move a complete replication-scenario to other
computers using backup and restore?
I realized, that a normal restore of a subsciber database loses all the
replication-tables.
Is there a way do perform this action without losing the current
MSMerge_Content data?
I need this for example to test replication problems of customers in a
devoloping
environment.
Andreas,
this is only practical if the computers all have the same names as the
starting computers. If this is the case, you can follow the BOL instructions
for backup and restore of replicated databases.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)