Home > Archive > MS SQL Server > November 2005 > Re: [2005 beta 2] merge replication sql server to sql server mobile









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: [2005 beta 2] merge replication sql server to sql server mobile
DannyCheah

2005-11-08, 9:23 am


Hi Diemo

I am facing the same problem...check the newsgroup and could not find
any answers. Could u help me. Many thanks.

Regards
Danny Cheah
Malaysia.


dieweb wrote:
> *Hello,
>
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005
> supports
> this, but it doesn't work.
>
> I created a publication for merge replication in my server database,
> but
> when i try to subscribe from my mobile database, i get the following
> error:
> ####################
####################
####################
############
> - Beginning Synchronization (Success)
>
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
>
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for
> this
> publication. If this snapshot is currently being generated, wait for
> the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
>
> The operation could not be completed.
>
>
> - Finalizing Synchronization (Stopped)
>
> - Saving Subscription Properties (Stopped)
> ####################
####################
####################
############
>
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in
> the
> replication folder.
> And I don't know whats the right argument for "distributor" to run
> the
> snapshot agent manually (snapshot.exe). I thought its the server,
> but
> doesn't work.
>
> Has anybody an idea, wheres my failure? Does anybody get something
> like
> this to work and can give a short howto?
>
> Best regards
>
> Diemo *




--
DannyCheah
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1239516.html

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com