sql server replication: RE: Is @sync_type = N'none' for merge safe? -- sql server replication

RE: Is @sync_type = N'none' for merge safe?

Chris
5/4/2006 11:41:02 PM

sql server replication:
Took backup of pubdb & restored at subscriber. Merge agent now displaying
'Processing article tblCustomer' - along with 5 other large (1Mill+ records)
tables. Then a series of 'Downloaded..100 updates..87 updates..68 updates..

Profiled subscriber, found
-- exec sp_MSgetmetadatabatch
-- exec sp_MSenumcolumns
- exec sp_MSinsertgenhistory
- exec sp_MScheckexistsgeneration
-- exec sp_MSupdategenhistory
-- exec [sp_upd_DC27BBA32A944AD5055D82E5EAF34552]

Any idea how long this will take to process?

Any help much appreciated...

RE: Is @sync_type = N'none' for merge safe?

Chris
5/5/2006 8:49:02 AM

Am I really gaining anything other than speeding up the bcp push process
when manually init merge subscribers?

The subscriber seems to choke on the meta data updates regardless....

Chris

[quoted text, click to view]

RE: Is @sync_type = N'none' for merge safe?

Chris
5/5/2006 9:39:01 AM

A little more info... since subscriber is subset of production, I could not
do complete restore of subscr database. I restored to staging db on same
server & dts'd data into subscr db. Then fired up merge agent... my guess -
merge system tables not populated, therefore sql forced to chug thru meta
data updates.

I will take backup of working subscriber & do complete restore, allowing me
to test this theory...

[quoted text, click to view]

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.