sql server replication: merge replication restore backup -- sql server replication

merge replication restore backup

Paul Ibison
12/21/2004 5:26:26 AM

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)

RE: merge replication restore backup

georg notter
12/21/2004 9:17:05 AM

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?
[quoted text, click to view]

Re: merge replication restore backup

Paul Ibison
12/21/2004 7:35:26 PM

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)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.