merge replication restore backup

Georg,
please can you give a bit more info. You want to copy
database 1 to database 2 - on the same server? is
database 2 to be used for reporting? is database 2 to be
a publisher or a subscriber? etc.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
ok i have 8databases puslished on the same machine.
on a second machine i've got 8 subscribers.
no database is used for reporting (?).
now i wanna copy the information from the replicated pair (db1publisher &
db1subscriber) to the second pair (db2publisher - db2subscriber).
you can imagine now, what i wanna do?
"Paul Ibison" wrote:

> Georg,
> please can you give a bit more info. You want to copy
> database 1 to database 2 - on the same server? is
> database 2 to be used for reporting? is database 2 to be
> a publisher or a subscriber? etc.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||The replication details won't transfer without a lot of hacking system
tables. The only viable way is to back up the databases and restore them on
the alternative servers. You can script out the original replication
settings, find and replace the servernames and logins then run the script on
the new servers. After that, you'll need to reinitialize.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)