Merge Subscription Without a Snapshot -- sql server replication

D Johnson
3/14/2006 12:07:27 PM

I'm trying to achieve this by backing up the database on the Publisher
immediately after I have configured publishing and restoring this backup on
the Subscriber SQL Server. When I am configuring the Subscriber I clear the
Initialize check box on the Initialize Subscriptions page of the New
Subscription Wizard. Finally I force a manual synchronization and am met
with failure.

What I have noticed is that after restoring to the Subscriber all the
rowguid columns are missing. I'm sure these are required.

Any help gratefully received.

D Johnson
3/14/2006 1:08:28 PM

I figured it out. If I want to bypass initializing with a snapshot and use
the backup method I needed to manually create the uniqueidentifier columns.
Everything works fine after this.

Regards
David

[quoted text, click to view]

Paul Ibison
3/14/2006 10:04:13 PM

David,
it won't work if you manually create the rowguids on the subscriber as
they'll have different values. Can you explain exactly what you did. For a
nosync initializqation you normally restore a backup, in which case the
rowguids should remain.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

D Johnson
3/15/2006 12:34:27 AM

Hi Paul

No, I didn't manually create the rowguids at the Subscriber. I manually
created them on the database that I wanted to Publish, before I even started
configuring for replication.

I tried several times allowing the rowguids to be created by the Publication
wizard but immediately prior to configuring the Subscriber I backed the
database to be replicated up only to find that when I restored on the server
that had yet to be configured as the Subscriber the rowguids were not present.

Regards
David

[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 about sql server replication

sql server replication : Merge Subscription Without a Snapshot