Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Merge Replication across internet, "The merge process was unable to deliver the snapshot to the Subscriber. " Expand / Collapse
Author
Message
Posted Monday, July 14, 2008 6:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 1:22 AM
Points: 330, Visits: 962
Hi,

I am getting the following error message while configuring replication across internet, please suggest.


The merge process was unable to deliver the snapshot to the Subscriber.
If using Web synchronization, the merge process may have been unable to
create or write to the message file. When troubleshooting,
restart the synchronization with verbose history logging and
specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001

With Regards
Post #533424
Posted Tuesday, July 15, 2008 6:44 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, February 8, 2013 7:22 AM
Points: 89, Visits: 118
Hi,

Are you using a virtual directory to delivery the file?

Could you send some more details about the publishing you're using?

Att,
Post #534311
Posted Friday, February 19, 2010 1:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 8:55 AM
Points: 19, Visits: 38
Hi

I'm getting the same error you told here. Had you been able to fix it?

I'm totally desperate...

Thanks in advance

Jesus
Post #868821
Posted Friday, February 19, 2010 5:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, February 8, 2013 7:22 AM
Points: 89, Visits: 118
Does that replication ever worked properly before?

Please send more details about the configuration.

Att,
Post #868972
Posted Friday, February 19, 2010 5:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 8:55 AM
Points: 19, Visits: 38
Hi Bruno

Thanks for your help.

I'll fixed already. Making changes on my publication I've found that the default snapshot folder was in format C:\MyFolder\MySnapshotFolder
I've changed it by an UNC format (\\MYSERVER\MySnapshotFolder) and I don't get the error anymore.
I hope my experience helps to someone...

Thanks again Bruno
Post #868983
Posted Wednesday, April 17, 2013 10:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 18, 2013 12:22 AM
Points: 1, Visits: 2
Hello,

I experienced the same kind of problem.

In a merge replication with SQL Express 2012, I got the error when applying the snapshot to the subscriber.
On server side, the database file is about 7.5 Gb.

Strange fact ... at the moment of the error : my database file (on the subscriber) is exactly sized to 4Gb but ... I read somewhere SQL Express 2012 file limitation was extended to 10Gg ...

An idea ?

Kind regards
Post #1443353
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse