Friday, March 23, 2012
merge replication restore backup
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)
Monday, March 12, 2012
merge replication metedata cleanup error
Hi,
We have a merge subscription which is reporting the following error at the subscriber:
The Merge Agent failed after detecting the retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet set to the Subscriber. You must reinitalize the subscription (without upload)
I'm a bit confused about this - there have been no changes made at the publisher - why would we be getting this message?
thanks
Bruce
The data changes that the merge agent is referring to are the metadata contained in the merge tables MSmerge_contents, MSmerge_tombstone, MSmerge_genhistory. Periodically this data needs to be purged otherwise it starts to impact performance.
If the retention period is passed the subscription will expire as the meta data will be removed. You will need to reinitialize the subscription. Here is some more information about setting the retention period.
http://msdn2.microsoft.com/en-us/library(d=robot)/ms151188.aspx
Thanks
Nabila Lacey